LDT Creation and Upload

Login 8004 instance.

CONNECT PUTTY -

cd $FND_TOP

cd patch              

cd 115

cd import

pwd

CREATE DATA DEFINITION LDT

FNDLOAD apps/app8004s0tst O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXESRETROREPORT.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="XXES" DATA_SOURCE_CODE="XXESRETROREPORT" TMPL_APP_SHORT_NAME="XXES" TEMPLATE_CODE="XXESRETROREPORT"

Crate Responsibility ldt

Create ldt in 8004 instance

FNDLOAD apps/app8004s0tst O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct "ACCOUNTING PERIOD_HO.ldt" FND_RESPONSIBILITY RESP_KEY="ACCOUNTING PERIOD_HO"

FNDLOAD apps/apps80040tst 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct ESCORTS_FSN_RED.ldt FND_RESPONSIBILITY RESP_KEY="ESCORTS FSN ITEM APPROVAL RED"

Copy this ldt into your location

Upload ldt in 8003 instance

Paste all the ldt into PWD location in 8003 instance

CONNECT PUTTY -

cd $FND_TOP

cd patch

cd 115

cd import

pwd

            

FNDLOAD apps/apps80030dev 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct ESCORTS_EXPORT_DOCUMENTS.ldt

To Upload Concurrent Program

FNDLOAD apps/app8005s0appdev 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXES_ECE_ITEM_WISE_BILLING.ldt

Check through the Backend

              

               SELECT * FROM FND_RESPONSIBILITY

               WHERE RESPONSIBILITY_KEY='ESCORTS_EXPORT_DOCUMENTS'

Craete Lookup ldt in 8004

              

               FNDLOAD apps/apps80040tst 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXES_EXP_LCTYPE.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXES_EXP_LCTYPE" LOOKUP_TYPE="XXES_EXP_LCTYPE" 

              

FNDLOAD apps/apps80040tst 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXES_EXP_LCSTATUS.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXES_EXP_LCSTATUS" LOOKUP_TYPE="XXES_EXP_LCSTATUS"

Upload ldt in 8003 instance         

FNDLOAD apps/apps80030dev 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXES_EXP_LCTYPE.ldt

               

 FNDLOAD apps/apps80030dev 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXES_EXP_LCSTATUS.ldt

               

                FNDLOAD apps/apps80030dev 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXES_VENDORMAIL_NOTIFICATION.ldt

MENU

FNDLOAD apps/apps80040tst 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct SPD_WMS_NAVIGATE.ldt MENU MENU_NAME="WMS_NAVIGATE"

FNDLOAD apps/apps80030dev 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXES_IRISO_KITS.ldt MENU MENU_NAME="ESCORTS_PO_NEW"

menu--

FNDLOAD apps/app8002s0tst 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXES_DEALER_SERVICE.ldt MENU MENU_NAME="XXES_DEALER_SERVICE"

RG_group--

FNDLOAD apps/app8002s0tst 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct EAM_Dealer_Readiness.ldt REQUEST_GROUP REQUEST_GROUP_NAME="EAM_Dealer_Readiness" APPLICATION_SHORT_NAME="XXES"

responsiblity--

FNDLOAD apps/app8002s0tst 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct EAM_Dealer_Readiness_Service.ldt FND_RESPONSIBILITY RESP_KEY="EAM Dealer Readiness Service"

Program-

FNDLOAD apps/app8005s0appdev O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXES_ECE_ORDER_BOOKING_STATUS.ldt PROGRAM APPLICATION_SHORT_NAME="XXES" CONCURRENT_PROGRAM_NAME="XXES_ECE_ORDER_BOOKING_STATUS"

Form Function

FNDLOAD apps/app8002s0tst 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct ESCORTS_UPDATE_WRT_DEFECT.ldt FUNCTION FUNCTION_NAME="ESCORTS UPDATE WRT DEFECT"

                                                                           New Codes

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