Migrate Descriptive Flex Fields (DFF) from one instance to another using FNDLOAD

         The oracle apps Descriptive Flex Fields (DFF) in one instance can be migrated/moved to another instance using FNDLOAD. You can follow the below steps for the same.

Step 1:
Edit the below FNDLOAD script.
To Copy select+ctrl+C
FNDLOAD apps/XXX O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=’COL_ALL:REF_ALL:CTX_ONE:SEG_ALL’ APPLICATION_SHORT_NAME="Application Short Name" DESCRIPTIVE_FLEXFIELD_NAME="DFF Name" P_CONTEXT_CODE="Context code"

Note: You need to enter 1) *.ldt file name
                                        2)Application short name
                                        3)DFF Name
                                        4)Context code

You can find the p_context_code from below navigation

 








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

Step 3:Modify the below script
FNDLOAD apps/XXXX O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct File_Name.ldt

Note: You need to enter the *.ldt file name which you have exported and apps credential

Step 4:Execution of FNDLOAD script
                      • 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:  Step 2 and Step4 are DBA tasks