How to migrate a Concurrent Program using FNDLOAD

The concurrent programs exist/created in one instance can be migrated/moved to another instance. You can follow the below steps for the same.

 Step 1: 

Query the concurrent program from the source instance and note down the concurrent program short name 

Step 2: 

Find the application short name from backend by using application name in the concurrent program.

SELECT fa.application_short_name

  FROM fnd_application fa

      ,fnd_application_tl fat

 WHERE fa.application_id = fat.application_id

 AND fat.language = 'US'

 AND UPPER (application_name) LIKE UPPER(:Application_name);

Step 3: 

Edit the below FNDLOAD script.

FNDLOAD apps/<<XXXXXXXXXX>> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXXXXXXX.ldt PROGRAM APPLICATION_SHORT_NAME="XXX" CONCURRENT_PROGRAM_NAME="XXXXXXXXXXX"

You need to enter 1) apps password

                            2) *.ldt file name (which is marked as ‘XXXXXXXX.ldt in the above script)

                            3) APPLICATION_SHORT_NAME (It is the output of the query mentioned in step 2)

                            4) CONCURRENT_PROGRAM_NAME (it is concurrent program short  name)

Step 4: Execution of FNDLOAD script        

·         Log into unix as application user

·         Enter apps password

·         Execute the modified script in the step 3

·         The *.ldt file will be generated on the same directory i.e pwd

 

Step 5:

·         Log into destination instance from unix  as application user

·         Place the *.ldt file to the directory i.e pwd

Step 6:

Modify the below script.

FNDLOAD apps/<<XXXXXXXXX>> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXXXXXXXXXX.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

·         Enter the apps password.

·         Enter the *.ldt file name which is placed in step5

·         Execute the modified script.

Note: No need to migrate dependent objects like value set explicitly . The dependent AOL objects will be migrated with concurrent programs.
Tips: It is better to take back up of concurrent program/dependent AOL objects from destination instance.