fndload script for lookups with values

fndload script for lookups with values

In this post , We will be discuss about fndload script for lookups with values. Oracle has provided the fndload script to migrate the lookups with values from oracle apps instance to another instance. fndload script creates the ldt file for lookup with values which contains all about registrations details for lookups. This ldt file stores all the information about lookups which helps to create the lookup with values in target oracle instance. Using fndload script is one of useful oracle shared script to automate the process of AOL objects registration like lookups from one Oracle apps instance to another instance. Here below is the detail about fndload script for lookups with values.

fndload script for lookups with values

What is the Purpose of fndload script for lookups with values?

Using fndload command , We can download the complete registration of lookups with values in the ldt files. This LDT file store the complete registration detail for the lookups. We just need to execute this LDT file in the Target oracle apps instance in which we want to register or create the lookups with values.

Benefits of fndload script for lookups with values

1. Single LDT files , helps to contain all the registration details for the lookups.

2.Single LDT file , help to register the Complete lookups detail in target oracle apps r12 instance.

3.It helps to save the Time , As we don't need to manually create the lookups.

4. Error free job , As it does not require manual intervention to create lookups in target instance.

5.It help to automate the process to AOL objects creation from one instance to another.

6.It more beneficial in Oracle implementation project, where we need to migrate the hundreds of lookups from Test Instance to Production target Instance.

9 Important Steps using fndload script for lookups with values

Step 1. First We need to know the LOOKUP_TYPE name and Application short name.

Step 2. Then we need to go the Oracle Application server back using PUTTY tool or any other tool and go to any Location under which we want to generate the ldt file.

Step 3.In Putty , where we want to create the ldt file for lookups with values in Oracle server , then we need to execute this below FNDLOAD script.

For Example LOOKUP Name is '<LOOKUP_CODE>' for which we want to create the ldt files.

NOTE : apps/<PWD> is the DB user name and password.

FNDLOAD Script to Dowlnload lookups with values

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct <LDT_FILE_NAME>.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="APP_SHORT_NAME" LOOKUP_TYPE="<LOOKUP_CODE>"

FNDLOAD Script to Dowlnload Value Set Values

Step 4:- 

After Executing this FNDLOAD download script , the ldt file will be created automatically for the LOOKUP Name is '<LOOKUP_CODE>'  in the same directory path from where we are executing this FNDLOAD script. LDT name will be <LDT_FILE_NAME> as we have given in the Script for LOOKUPS ldt File , we have given the name "<LDT_FILE_NAME>.ldt". We need to copy this ldt files in our local desktop from application server.

Step5:- After creating the LDT script and copy into the local desktop, we need to go towards our source/target Oracle application instance in which we want to register/create the LOOKUPS with values.

Step 6:- Now , we need to upload the LDT file from Local System to the Source/target system Application server location using any FTP tool.

Step 7:- After copy the LDT file from Local System to the Source/target system Application server location , We need to login the target system server backend using PUTTY tool.

Step 8:- In Putty , We need to go the same location under which we have upload or copy the file Local System to the Source/target system Application server and then execute this below script.

FNDLOAD Script to Upload Value Set

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

Step 9 :- After Executing this above script , Our lookups with values will be created in the Target instance automatically.

fndload script for lookups with values