FNDLOAD - Upload, download oracle program definitions

| No Comments | 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

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.

Create Oracle Receivables Invoice using public API is the next entry in this blog.

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