Migrate form and functions from one instance to another using FNDLOAD

     The oracle apps form and functions in one instance can be migrated/moved to another instance using FNDLOAD. You can follow the below steps for the same.

Step 1:
Find the form and function name which you are going to migrate.
You can refer below 2 tables
select * from fnd_form
select * from fnd_form_functions

Step 2:
Edit the below FNDLOAD script 

Export form:
To Copy code Select+ctrl+C
FNDLOAD apps/XXXXX O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FORM APPLICATION_SHORT_NAME="XXXX" FORM_NAME='form name'

Export Function:
To Copy code Select+ctrl+C
FNDLOAD apps/XXXXX O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FUNCTION APPLICATION_SHORT_NAME="XXXX" FUNCTION_NAME='Function Name'

Note: You need to enter a) Apps Credential
                                        b)ldt file name
                                        c) Application short name
                                        d)form/function name 

Step 3:
Execution of FNDLOAD script
               * Log into unix as application user
               * Enter apps password
               * Execute the modified script in the step 2
              * The *.ldt file will be generated on the same directory i.e pwd

Step 4:
Modify the below script 

Form Import:
To Copy code Select+ctrl+C
FNDLOAD apps/xxxxxxx O Y UPLOAD @FND:patch/115/import/afsload.lct file_name.ldt

Function Import:
To Copy code Select+ctrl+C
FNDLOAD apps/xxxxxx O Y UPLOAD @FND:patch/115/import/afsload.lct file_name.ldt

Note: You need to enter the *.ldt file name which you have exported and apps credential
Step 5:
* Log into destination instance from unix as application user
* Place the *.ldt file to the directory i.e pwd
* Enter the apps password.
* Execute the modified script.

Note: The step 3 and step 5 are DBA taskes. You can contact your DBA to execute the FNDLOAD scripts