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
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
No comments :
Post a Comment