Search This Blog

Tuesday, September 10, 2013

Download LDT Files using FND_LOAD based on Custom Selection

Download LDT Files using FND_LOAD based on Custom Selection:

Sometimes we have the requirement like we need to create hundreds of concurrent programs from one instance to another. One option is to download LDT files for each concurrent program. But we need to create 100 command to download and upload the file.

Here is the simple, you can do. Write the select query in SQL Developer and develop the script like that based on your selection.

SELECT 'FNDLOAD apps/ur_password O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct '||A.CONCURRENT_PROGRAM_NAME||'.ldt PROGRAM APPLICATION_SHORT_NAME= "' 
       || B.APPLICATION_SHORT_NAME ||'"' || ' CONCURRENT_PROGRAM_NAME="'|| A.CONCURRENT_PROGRAM_NAME||'"'
FROM 
FND_CONCURRENT_PROGRAMS A, FND_APPLICATION B
WHERE 1=1
AND A.APPLICATION_ID = B.APPLICATION_ID
AND A.CONCURRENT_PROGRAM_NAME LIKE 'XX%'
AND B.APPLICATION_SHORT_NAME LIKE 'XX%';

Take all the rows and paste it in Notepad++ and change the file type to SH e.g. Sample_LDT_Files.sh.
Run that Shell script in Putty in your specified folder and it will download all the files to your folder.

Move the Files to your next instance and run the UPLAOD command in the same way in that instance.
It will create all the objects there :)