1. Lookups
-- -------------
FNDLOAD apps/apps O 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"
FNDLOAD apps/apps O Y UPLOAD
$FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE
CUSTOM_MODE=FORCE
2. Concurrent Program
-- -----------------------------
FNDLOAD apps/apps O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM
APPLICATION_SHORT_NAME="XXCUST"
CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt - WARNING=YES
UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
3. Profile
-- ---------
FNDLOAD apps/apps O Y DOWNLOAD
$FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt PROFILE
PROFILE_NAME="XX_PROFILE_NAME"
APPLICATION_SHORT_NAME="XXCUST"
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt - WARNING=YES
UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
4. Request Set and Link
-- ------------------------------
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afcprset.lct XX_CUSTOM_RS.ldt REQ_SET
REQUEST_SET_NAME='REQUEST_SET_NAME'
FNDLOAD apps/apps O Y UPLOAD
$FND_TOP/patch/115/import/afcprset.lct XX_CUSTOM_RS.ldt
UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
5. FND Message
-- ---------------------
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt FND_NEW_MESSAGES
APPLICATION_SHORT_NAME="XXCUST"
MESSAGE_NAME="MESSAGE_NAME%"
FNDLOAD apps/apps O Y UPLOAD
$FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt UPLOAD_MODE=REPLACE
CUSTOM_MODE=FORCE
6. D2K FORMS
-- ------------------
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt FORM
FORM_NAME="FORM_NAME"
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt - WARNING=YES
UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
7. Form Function
-- ---------------------
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt FUNCTION
FUNCTION_NAME="FORM_FUNCTION_NAME"
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt - WARNING=YES
UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
8. 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
9. Value Set
-- --------------
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET
FLEX_VALUE_SET_NAME="XX Value Set Name"
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES
UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
10. Data Definition and Associated Template
---
----------------------------------------------------------
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD
$XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt XDO_DS_DEFINITIONS
APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='XX_SOURCE_CODE'
TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='XX_SOURCE_CODE'
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD
$XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt
11. 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
12. 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
13 - Request Group
FNDLOAD
apps/******(password) O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct
DATALOADERFILE.ldt REQUEST_GROUP REQUEST_GROUP_NAME="Your Request Group
name" APPLICATION_SHORT_NAME="Your Request Group Application short
name" REQUEST_GROUP_UNIT UNIT_NAME="Your concurrent program short
name"