FNDLOAD LDT Script for Download and Upload.

FNDLOAD LDT Script for Download and Upload.

1. CONCURRENT PROGRAM.

--Download Script
 FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUSTAPP" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM";

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE;

2. DATA DEFINITION AND ASSOCIATED TEMPLATE.

--Download Script
 FNDLOAD apps/appspwd 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='XX_CUSTOM_DD_CODE' TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='XX_CUSTOM_DT_CODE';

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD ${XDO_TOP}/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt;

3. DATA_TEMPLATE (Data Source .xml file)

--Download Script
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -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;

--Upload Script
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -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 -APPS_SHORT_NAME XXCUST -LOB_CODE XX_TEMPLATE -NLS_LANG en -TERRITORY 00 -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME DATA_TEMPLATE_XXCUST_XXGL_XX_TEMPLATE.xml -CUSTOM_MODE FORCE -LOG_FILE $LOG_FILE_NAME;

4. RTF TEMPLATE (Report Layout .rtf file)

--Download Script
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -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 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME;

--Upload Script
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST='XX_HOST_NAME')(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEMPLATE -APPS_SHORT_NAME XXCUST -LOB_CODE XX_TEMPLATE -LANGUAGE en -TERRITORY 00 -XDO_FILE_TYPE RTF -FILE_NAME TEMPLATE_SOURCE_XXCUST_XX_TEMPLATE_en.rtf -CUSTOM_MODE FORCE -LOG_FILE $LOG_FILE_NAME;

5. ALERTS.

--Download Script
FNDLOAD apps/appspwd 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";

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE; 

6. VALUE SET.

 --Download Script
$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX - Value_Set_Name";

--Upload Script
 $FND_TOP/bin/FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE; 

7. VALUE SET WITH VALUES.

 --Download Script
$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="XX - Value_Set_Name";

--Upload Script
 $FND_TOP/bin/FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;

 8. WebADI - Web Desktop Integrator.

 --Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_INTEGRATOR.ldt BNE_INTEGRATORS INTEGRATOR_ASN="XXCUST" INTEGRATOR_CODE="XX_INTEGRATOR_CODE";


--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_INTEGRATOR.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE; 

9. FND MESSAGES.

--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUST" MESSAGE_NAME="XX MESSAGE_NAME" ;


--Upload Script 
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE; 

10. PROFILE.

 --Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRFL.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST";

--Upload Script 
$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRFL.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;

11. LOOKUP.

--Download Script--
--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE";

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;

12. REQUEST SET.

--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET.ldt REQ_SET REQUEST_SET_NAME='XX - REQUEST SET NAME';

--Upload Script
FNDLOAD apps/appspwd O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQ_SET.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE;

 13. FORM FUNCTION.

 --Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt FUNCTION FUNCTION_NAME="XXFORM_FUNCTION_NAME";

--Upload Script 
$FND_TOP/bin/FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE; 

14. REQUEST GROUP

--Download Script
FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REQST_GRP.ldt REQUEST_GROUP REQUEST_GROUP_NAME="XX - Request Group Name" APPLICATION_SHORT_NAME="XXCUST"; 
 

--Upload Script
FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REQST_GRP.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE;