FND Load

Oracle FND Loader Scripts

1. Regular Path

                          $FND_TOP/patch/115/import

2. Process

       Run the download scripts from DEV instance and place the files in         FND_TOP. Again place the same ldt file in PROD instance then run upload scripts.

3. FND Messages – afmdmsg.lct

     Download-

  FNDLOAD apps/$apps_password 0 Y DOWNLOAD

  $FND_TOP/patch/115/import/afmdmsg.lct

  your_filename.ldt

  FND_NEW_MESSAGES

  APPLICATION_SHORT_NAME="APPLICATION_SHORT_NAME"

  MESSAGE_NAME=message_name

     Upload-

  FNDLOAD apps/$apps_password 0 Y UPLOAD

  $FND_TOP/patch/115/import/afmdmsg.lct

  your_filename.ldt

UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

4. Lookups – aflvmlu.lct

     Download-

   FNDLOAD apps/$apps_password 0 Y DOWNLOAD

  $FND_TOP/patch/115/import/aflvmlu.lct

  your_filename.ldt

  FND_LOOKUP_TYPE

  APPLICATION_SHORT_NAME="APPLICATION_SHORT_NAME"

  LOOKUP_TYPE="lookup_type"

        Upload-

  FNDLOAD apps/$apps_password 0 Y UPLOAD

  $FND_TOP/patch/115/import/aflvmlu.lct

  your_filename.ldt

  UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

5. Concurrent Programs – afcpprog.lct

     Download-

FNDLOAD apps/$apps_password O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct your_filename.ldt PROGRAM APPLICATION_SHORT_NAME="APPLICATION_SHORT_NAME" CONCURRENT_PROGRAM_NAME="Program_Name"

Upload-

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

6. Menus – afsload.lct

Download-

  FNDLOAD apps/$apps_password 0 Y DOWNLOAD

  $FND_TOP/patch/115/import/afsload.lct

  your_filename.ldt

  MENU

  MENU_NAME="Menu_Name"

  APPLICATION_SHORT_NAME="APPLICATION_SHORT_NAME"

Upload-

  FNDLOAD apps/$apps_password 0 Y UPLOAD

  $FND_TOP/patch/115/import/afsload.lct

  your_filename.ldt

  UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

7. Responsibility – afscursp.lct

Download-
  FNDLOAD apps/$apps_password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afscursp.lct
  your_filename.ldt
  FND_RESPONSIBILITY

  RESP_KEY="Responsibility"

Upload-
  FNDLOAD apps/$apps_password 0 Y UPLOAD
  $FND_TOP/patch/115/import/afscursp.lct
  your_filename.ldt

  UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

8. Form Functions – afsload.lct

Download-
  FNDLOAD apps/$apps_password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afsload.lct
  your_filename.ldt
  FUNCTION 

  FUNCTION_NAME="Function_Name"

Upload-
  FNDLOAD apps/$apps_password 0 Y UPLOAD
  $FND_TOP/patch/115/import/afsload.lct
  your_filename.ldt - WARNING=YES

  UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

9. Alerts – alr.lct

Download-
  FNDLOAD apps/$apps_password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/alr.lct
  your_filename.ldt
  ALR_ALERTS
  APPLICATION_SHORT_NAME="APPLICATION_SHORT_NAME"

  ALERT_NAME="Alert_Name"

Upload-
  FNDLOAD apps/$apps_password 0 Y UPLOAD
  $FND_TOP/patch/115/import/alr.lct
  your_filename.ldt

  CUSTOM_MODE=FORCE

10. Value Sets – afffload.lct

Download-
  FNDLOAD apps/$apps_password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afffload.lct
  your_filename.ldt
  VALUE_SET

  FLEX_VALUE_SET_NAME="Value_Set_Name"
Upload-
  FNDLOAD apps/$apps_password 0 Y UPLOAD
  $FND_TOP/patch/115/import/afffload.lct
  your_filename.ldt - WARNING=YES

  UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

11. User – afscursp.lct

Download-
  FNDLOAD apps/$apps_password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afscursp.lct
  your_filename.ldt
  FND_USER 

  USER_NAME="User_Name"

Upload-
  FNDLOAD apps/$apps_password 0 Y UPLOAD
  $FND_TOP/patch/115/import/afscursp.lct
  your_filename.ldt

  UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

12. Request Groups – afcpreqg.lct

Download-
  FNDLOAD apps/$apps_password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afcpreqg.lct
  your_filename.ldt
  REQUEST_GROUP
  REQUEST_GROUP_NAME="Request_Group_Name"

  APPLICATION_SHORT_NAME="APPLICATION_SHORT_NAME"

Upload-
  FNDLOAD apps/$apps_password 0 Y UPLOAD
  $FND_TOP/patch/115/import/afcpreqg.lct
  your_filename.ldt

  UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

13. D2K Forms

Download-
$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"

Upload-
$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

14. XML File

Download-
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

Upload-
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

15. RTF Template

Download-
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

Upload-
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