FNDLOAD - Upload, download oracle program definitions

| 1 Comment | No TrackBacks
Need to migrate concurrent program definition from one instance to another without creating it again manually. Say the program definitions have to be moved from Instance A to B.

1. Download the program definitions from one instance using FNDLOAD command
2. Use the .ldt file for download and upload, run the scripts in the UNIX box. Get the output
3. Upload the program definition using FNDLOAD command

Execute this in Source Instance A
FNDLOAD usr/pwd@instance 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct PRG_XX.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XX_CP"

Get the PRG_XX.ldt output file and copy into local.

Then execute the below upload in Instance B where the definition needs to be migrated.

FNDLOAD usr/pwd@instance 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct PRG_XX.ldt 

Related Posts:
http://oracle.anilpassi.com/oracle-fndload-script-examples.html
http://www.oracleappshub.com/aol/its-all-about-fndload/

No TrackBacks

TrackBack URL: http://chandramouly.com/MT/mt/mt-tb.cgi/16

1 Comment

FNDLOAD is a great tool and make it even grater, iTerra Consulting developed MigrationLogiK - GUI for FNDLOAD. It makes the entire migration experience more efficient (x100 times), and allows distribute activities not only among developers but among fuctional analysts as well. It has some cool features like - retreive all the FND objects created or updated by a certain user or select Profile Options having values set for a certain responsibility. It can be downloaded from MigrationLogiK web site

Leave a comment

About this Entry

This page contains a single entry by chandramouly published on May 5, 2010 10:47 PM.

Extract tables from Oracle Apps - Code migration between instances was the previous entry in this blog.

Find recent content on the main index or look in the archives to find all content.