FNDLOAD is an Oracle utility that allows for the transfer of a wide range of Oracle Foundation (FND) data from one instance to the other. The loader reads a configuration file (LCT) to determine what data to access. It works by downloading the data in the source instance into a text file (LDT file) that can then be uploaded into target instances. FNDLOAD ensures consistent migration of the objects within Oracle Applications
- Concurrent Program
— —————————–
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CON_PROG_SHORT_NAME.ldt PROGRAM APPLICATION_SHORT_NAME=”XXCUST” CONCURRENT_PROGRAM_NAME=”XX_CON_PROG_SHORT_NAME”
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CON_PROG_SHORT_NAME.ldt – WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
- Lookups
— ————-
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXCUST_LOOKUPTYPE.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”XXCUST” LOOKUP_TYPE=”XXCUST_LOOKUPTYPE”
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXCUST_LOOKUPTYPE.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
- Profile
— ———
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XXCUST_PROFILE.ldt PROFILE PROFILE_NAME=”XXCUST_PROFILE” APPLICATION_SHORT_NAME=”XXCUST”
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XXCUST_PROFILE.ldt – WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
- Request Set and Link
— ——————————
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUST_REQUESTSET.ldt REQ_SET REQUEST_SET_NAME=”XXCUST_REQUESTSET”
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUST_REQSET_LINKS.ldt REQ_SET_LINKS REQUEST_SET_NAME=”XXCUST_REQUESTSET”
Links
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUST_REQUESTSET.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XXCUST_REQSET_LINKS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
- FND Message
— ———————
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXCUST_MSG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=”XXCUST” MESSAGE_NAME=”XXCUST_MSG”
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXCUST_MSG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
- Alerts
— ———
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XXCUST_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME=”Alert Name”
FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XXCUST_ALR.ldt CUSTOM_MODE=FORCE
- Value Set
— ————–
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXCUST_VALSET.ldt VALUE_SET FLEX_VALUE_SET_NAME=”Custom Value Set Name”
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXCUST_VALSET.ldt – WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
- Forms personalization
— ————–
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct ARXTWMAI.ldt FND_FORM_CUSTOM_RULES form_name=ARXTWMAI
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct ARXTWMAI.ldt
- Data Definition and Associated Template
— ———————————————————-
FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXCUST_DD_TEMPLATE.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XBOL DATA_SOURCE_CODE=XXCUST_DD_TEMPLATE
FNDLOAD apps/trxappsttrxi 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXCUST_DD_TEMPLATE.ldt
- DATA_TEMPLATE (Data Source .xls and RTF file)
— ———————————————————-
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOST NAME)(PORT=PORT NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE NAME)))’ -LOB_TYPE TEMPLATE -LOB_CODE XXCUST_CODE -APPS_SHORT_NAME XBOL -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE XXCUST_CODE.log
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOST NAME)(PORT=PORT NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE NAME)))’ -LOB_TYPE TEMPLATE -LOB_CODE XXCUST_CODE -XDO_FILE_TYPE RTF -FILE_NAME XXCUST_CODE_RTF_FILE.rtf -APPS_SHORT_NAME XBOL -LANGUAGE en -TERRITORY 00 -CUSTOM_MODE FORCE -LOG_FILE XXCUST_CODE_RTF_UPLOAD.log