How to upload ldt file for concurrent program

How to upload ldt file for concurrent program

In this post , We will be discuss about How to upload ldt file for concurrent program. ldt file for concurrent program is the registration file for the concurrent programs. This Registration ldt file having all the required information to register one concurrent program in other oracle apps instance. This is the functionality provided in oracle r12 to ease the process of AOL objects migrations in one instance to another instance. LDT file is one of the used practice , when you are migrating the hundreds of concurrent program from Test instance to Production instance for a project. Here below we will describe in detail about How to upload ldt file for concurrent program

What is the use of LDT file for Concurrent program ?

LDT file for concurrent program help to register the concurrent program in other instance. We do create the LDT file for concurrent program in source instance. This LDT file have all the required informations to register the concurrent program to target oracle apps instance. In LDT file , We have the information about Concurrent Program Executable Details , Concurrent Program Registrations Details , Concurrent Program Parameter Details , Concurrent Program Values registration details and other AOL object registration details which are dependent on concurrent program. We just need to upload the ldt file to the source instance and the Concurrent Program will be registered automatically in the source instance and its dependent AOL objects like , Executable , Parameters , Value sets will also create automatically through this LDT file. 

Benefits of ldt file for concurrent program

1. Single LDT files , helps to contain all the registration details for the Concurrent Program and other dependent AOL objects of the Concurrent Program.

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

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

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

Important Script to upload ldt file for concurrent program

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

9 Important Steps to Create and Upload LDT files for concurrent Program

Step 1. First We need to know the CONCURRENT_PROGRAM_NAME and Application Short Name for the concurrent program which we want to create the LDT file.

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 concurrent program in Oracle server , then we need to execute this below FNDLOAD script.

For Example concurrent Program Name is 'XXAPAGING' for which we want to create the ldt files.

Application Short Name is 'AP'

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

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXAPAGING.ldt PROGRAM APPLICATION_SHORT_NAME="AP" CONCURRENT_PROGRAM_NAME="XXAPAGING";

Step 4:- 

After Executing this FNDLOAD download script , the ldt file will be created automatically for the concurrent Program Name is 'XXAPAGING' in the same directory path from where we are executing this FNDLOAD script. LDT name will be same as Concurrent Program short name as we have given in the Script. We need to copy this ldt file 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 the concurrent program. 

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 apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXAPAGING.ldt

Step 9 :- After Executing this above script , Our Concurrent Program will be created in the Target instance and other dependent AOL objects of this Concurrent program will be created automatically.