fndload command to download value set with values

fndload command to download value set with values

In this post , We will be discuss about fndload command to download value set with values. FNLOAD command is provided by oracle apps to create the LDT file for AOL Objects registrations. Using fndload command , we can download the registration of any Value set and its given values values in the form of LDT file and then execute this LDT file in Target Oracle apps instance to Create the Value set and its given values automatically in oracle apps instance. fndload command is one of useful oracle shared script to automate the process of AOL objects registration like Value set from one Oracle apps instance to another instance. Here below is the detail about fndload command to download value set with values.

What is the Purpose of fndload command to download value set with values ?

Using fndload command , We can download the complete registration of Value set and its detail value set values in the single ldt file. This LDT file store the complete registration detail for the value set. We just need to execute this LDT file in the Target oracle apps instance in which we want to register or create the value set and upload the value set values.

fndload command to download value set with values

Benefits of fndload command to download value set with values

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

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

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

4. Error free job , As it does not require manual intervention to create value set 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 concurrent program value sets from Test Instance to Production target Instance.

Important fndload command to download value set with values

FNDLOAD is the standard script provided by oracle to create create ldt files for Concurrent Program.

9 Important Steps using fndload command to download value set with values

Step 1. First We need to know the Value Set 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 value set and value set values in Oracle server , then we need to execute this below FNDLOAD script.

For Example Value Set Name is 'XX_DEBUG_FLAG' for which we want to create the ldt files.

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

FNDLOAD Script to Dowlnload Value Set 

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_DEBUG_FLAG.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX_DEBUG_FLAG"

FNDLOAD Script to Dowlnload Value Set Values

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_DEBUG_FLAG_VALUE.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="XX_DEBUG_FLAG"

Step 4:- 

After Executing this FNDLOAD download script , the ldt file will be created automatically for the Value Set Name is "XX_DEBUG_FLAG" in the same directory path from where we are executing this FNDLOAD script. LDT name will be same as Value Set short name as we have given in the Script for Value Set Values ldt File , we have given the name "XX_DEBUG_FLAG_VALUE.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 Value set 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/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_DEBUG_FLAG.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD Script to Upload Value Set Values 

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

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

fndload command to download value set with values