Migrating registrations of AOL Objects (Function/Concurrent Program/Alert/Menu) from one server instance to other server instance using LDT (FNDLOAD) files in Oracle APPS

Purpose: Here we will see how to move the registrations of different AOL objects like Forms, Concurrent Program, menu etc. from one server instance to other quickly.

 Steps:

• First create the LDT file. This file will be used to move the records.

• Login to FTP (SSH, Winscp, Toad) on the source server.

• Run the below mentioned script, as scripts are different for different AOL objects so as per the requirement run the script.

Function (Download)

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_FUNC_NAME.ldt FUNCTION FUNCTION_NAME="FORM_FUNCTION_NAME"

Concurrent Program (Download)

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

Lookup (Download)

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_LOOKUP_NAME.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUSTOP" LOOKUP_TYPE="LOOKUP_TYPE_NAME"

Menu (Download)

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_MENU_NAME.ldt MENU MENU_NAME="MENU_NAME"

Message (Download)

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_MESSAGE_NAME.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUSTOP" MESSAGE_NAME="MESSAGE_NAME"

Request Set and Link (Download)

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_REQUEST_SET.ldt REQ_SET REQUEST_SET_NAME="REQUEST_SET_NAME"

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_LINK_NAME.ldt REQ_SET_LINKS REQUEST_SET_NAME="REQUEST_SET_LINK"

Profile (Download)

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_PROFILE_NAME.ldt PROFILE PROFILE_NAME="PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUSTOP"

Alert (Download)

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_ALERT_NAME.ldt ALR_ALERTS APPLICATION_SHORT_NAME="XXCUSTOP" ALERT_NAME="ALERT_NAME"

• Refresh the directory and you will see the LDT file has been created with the specified name in the script.

• Check the log file to verify the script completed successfully.

• Download the LDT file on your system.

• Now, login to FTP (SSH, Winscp, Toad) on the destination server.

• Move the LDT file to any directory.

• Run the below mentioned script, as scripts are different for different AOL objects so as per the requirement run the script.

Function (Upload)

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

Concurrent Program (Upload)

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_PROGRAM_NAME.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Lookup (Upload)

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct  XX_LOOKUP_NAME.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Menu (Upload)

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_MENU_NAME.ldt

Message (Upload)

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_MESSAGE_NAME.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Request Set and Link (Upload)

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_REQUEST_SET.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_LINK_NAME.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Profile (Upload)

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_PROFILE_NAME.ldt 

Alert (Upload)

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_ALERT_NAME.ldt CUSTOM_MODE=FORCE