FNDLOAD

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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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