FNDLOAD commands

1. XML Publisher Data Definition and Templates
a) To download all Templates defined for a particular Data Definition


FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ldt_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[APPSHORTNAME] DATA_SOURCE_CODE=[DATADEFINITIONCODE]


b) To download for a particular Template and Data Definition


FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ldt_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[APPSHORTNAME] DATA_SOURCE_CODE=[DATADEFSHORTCODE] TMPL_APP_SHORT_NAME=[APPSHORTNAME] TEMPLATE_CODE=[TEMPLATECODE]


c) Upload RTF to XML Template

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD [APPSPWD] -JDBC_CONNECTION [DBHOST:DBPORT:SID] -LOB_TYPE TEMPLATE -APPS_SHORT_NAME [APPSHORTNAME] -LOB_CODE [TEMPLATESHORTNAME] -LANGUAGE en -TERRITORY [TERRITORYCODE] -XDO_FILE_TYPE RTF -FILE_CONTENT_TYPE 'application/rtf' -FILE_NAME [FILEPATH_ON_SERVER] -CUSTOM_MODE FORCE -LOG_FILE [LOGFILEPATH_ON_SERVER]


2. Concurrent Programs


FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct ldt_name.ldt PROGRAM APPLICATION_SHORT_NAME="APPSHORTNAME" CONCURRENT_PROGRAM_NAME="PROGSHORTNAME"


3. Request Set


a) To download Request Set Definition


FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct ldt_name.ldt REQ_SET APPLICATION_SHORT_NAME="APPSHORTNAME" REQUEST_SET_NAME="REQSETSHORTNAME"


b) To download Request Set Link Stage Definition


FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct ldt_name.ldt REQ_SET_LINKS APPLICATION_SHORT_NAME="APPSHORTNAME" REQUEST_SET_NAME="REQSETSHORTNAME"

4. Flexfields

a) To download Flexfields

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct ldt_name.ldt DESC_FLEX APPLICATION_SHORT_NAME= ‘APPSHORTNAME’ DESCRIPTIVE_FLEXFIELD_NAME=’FLEXFIELD_CODE’

b) To upload Flexfields

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct ldt_name.ldt