Reference:
Most of its contents were taken from 'Dibyajyoti Koch: A Blog on Oracle Application' website for my own personal use. Please visit <https://imdjkoch.wordpress.com/tag/fndload> for its original contents along with other useful contents.
What is FNDLOAD?
- FNDLOAD is a developer tool provided by Oracle that migrates setup/configuration data from one instance to another
- This program is located in $FND_TOP/bin directory
- It is a human-readable file that is executed as a UNIX command line
- The program downloads a .ldt file from the Source instance. The program, then, uploads the .ldt file in the Target instance
What objects can be migrated by FNDLOAD?
- Concurrent Programs
- Request Groups
- Request Sets
- Responsibilities
- Forms
- Forms Personalizations
- Key Flexfields (KFF)
- Descriptive Flexfields (DFF)
- Functions
- Menus
- Lookups
- Value Sets
- Profile Options
- FND Users
- Printer Styles
Examples of FNDLOAD
1. Concurrent Programs > Download
FNDLOAD apps/&pswd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CONC_PROG.ldt PROGRAM APPLICATION_SHORT_NAME="SQLAP" CONCURRENT_PROGRAM_NAME="XX_CONC_PROG_SHORT_NAME"
Concurrent Programs > Upload
FNDLOAD apps/&pswd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CONC_PROG.ldt
Concurrent Programs: Upload Partial
FNDLOAD apps/&pswd 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afcpprog.lct XX_CONC_PROG.ldt PROGRAM CONCURRENT_PROGRAM_NAME="XX_CONC_PROG_SHORT_NAME" APPLICATION_SHORT_NAME="SQLAP"
2. Request Groups > Download
FNDLOAD apps/&pswd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_CONC_PROG_REQ_GRP.ldt REQUEST_GROUP REQUEST_GROUP_NAME='Payables Admin Reports' APPLICATION_SHORT_NAME='SQLAP' REQUEST_GROUP_UNIT UNIT_APP='SQLAP' UNIT_TYPE='P' UNIT_NAME='XX_CONC_PROG_SHORT_NAME'
Request Groups: Upload
FNDLOAD apps/&pswd 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afcpreqg.lct XX_CONC_PROG_REQ_GRP.ldt REQUEST_GROUP REQUEST_GROUP_NAME='Payables Admin Reports' APPLICATION_SHORT_NAME='SQLAP'
3. Request Sets > Download