FNDLOAD Scripts

FNDLOAD Command to download a Form.

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt FORM FORM_NAME="<FORM_FUNCTION_NAME>"

FNDLOAD apps/<Pwd> 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt FORM FORM_NAME="<FORM_FUNCTION_NAME>"

FNDLOAD Command to download a Form Function.

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt FUNCTION FUNCTION_NAME="<FORM_FUNCTION_NAME>"

FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD to download/Upload a Menu

FNDLOAD apps/<Pwd>  0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME >.ldt MENU MENU_NAME="<Menu_Name>"

FNDLOAD apps/<Pwd>   0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME >.ldt

Note: To attach a form function with an existing menu, download the menu from the source instance and delete all the functions except the one which you wanted to attach and then upload the edited ldt file in to the target instance. or use the below script

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt MENU PARENT_MENU_NAME="<MENU_NAME>" FUNCTION_NAME="<FORM_FUNCTION_NAME>"

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt

FNDLOAD Command to download a Concurrent Program.

FNDLOAD apps/<Pwd> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <LDT_FILE_NAME>.ldt PROGRAM APPLICATION_SHORT_NAME="<APP_SHORT_NAME>" CONCURRENT_PROGRAM_NAME="<CP_SHORT_NAME>"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct <LDT_FILE_NAME>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD Command to download a Request Group

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <LDT_FILE_NAME>.ldt REQUEST_GROUP REQUEST_GROUP_NAME="<RG name, not the code>" APPLICATION_SHORT_NAME="<APP_SHORT_NAME>"

FNDLOAD Command to download a Request Group for a specific Program.

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <LDT_FILE_NAME>.ldt REQUEST_GROUP REQUEST_GROUP_NAME="<RG name, not the code>" APPLICATION_SHORT_NAME="<APP_SHORT_NAME>" UNIT_NAME="<CP_SHORT_NAME>"

Note: In request group name, give the actual name and not the RG code.

FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct <LDT_FILE_NAME>.ldt

FNDLOAD Command to download a Template for a Data definition.

FNDLOAD apps/<Pwd>  O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct <LDT_FILE_NAME>.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="<APP_SHORT_NAME>" DATA_SOURCE_CODE="<DATA_DEFINITION_CODE>" TMPL_APP_SHORT_NAME="<TEMP_APPLICATION_SHORT_NAME>" TEMPLATE_CODE="<TEMPLATE_CODE>"

FNDLOAD apps/<Pwd> 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct <LDT_FILE_NAME>.ldt

FNDLOAD Command to download a Request Set

FNDLOAD apps/<Pwd>   0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <LDT_FILE_NAME>.ldt REQ_SET REQUEST_SET_NAME="<REQUEST_SET_SHORT_NAME>"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  <LDT_FILE_NAME>.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD Command to download the Link Stages for Request Set

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <LDT_FILE_NAME>.ldt REQ_SET_LINKS REQUEST_SET_NAME="<REQUEST_SET_SHORT_NAME>"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  <LDT_FILE_NAME>.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD Command to download a lookup

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct <LDT_FILE_NAME>.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="APP_SHORT_NAME" LOOKUP_TYPE="<LOOKUP_CODE>"

FNDLOAD apps/<PWD> O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct <LDT_FILE_NAME>.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD Command to download a Responsibility

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct <LDT_FILE_NAME>.ldt FND_RESPONSIBILITY RESP_KEY="<RESPONSIBILITY_KEY>"

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct <LDT_FILE_NAME>.ldt

FNDLOAD Command to download a Form Personalization

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <LDT_FILE_NAME>.ldt FND_FORM_CUSTOM_RULES FORM_NAME="<YOUR_FORM_NAME>"

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <LDT_FILE_NAME>.ldt

FNDLOAD Command to download a Value set

FNDLOAD apps/<PWD> O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct <LDT_FILE_NAME>.ldt VALUE_SET FLEX_VALUE_SET_NAME="<VALUE_SET_NAME>"

If value set has values then,

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct <LDT_FILE_NAME>.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="<VALUE_SET_NAME>"

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct <LDT_FILE_NAME>.ldt

FNDLOAD Command to download Profile Options

FNDLOAD apps/<PWD> O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct <LDT_FILE_NAME>.ldt PROFILE PROFILE_NAME="<PROFILE_OPTION_NAME>" APPLICATION_SHORT_NAME="APP_SHORT_NAME"

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct <LDT_FILE_NAME>.ldt

FNDLOAD Command to download Alerts

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX - Alert Name"

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE

FNDLOAD Command to download DATA_TEMPLATE(Data Source .xml file)

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME

FNDLOAD Command to download RTF TEMPLATE (Report Layout .rtf file)

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NAME.rtf -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME