Oracle FNDLOAD and Examples

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?

1. Concurrent Programs
2. Request Groups
3. Request Sets
4. Responsibilities
5. Forms
6. Forms Personalizations
7. Key Flexfields (KFF)
8. Descriptive Flexfields (DFF)
9. Functions
10. Menus
11. Lookups
12. Value Sets
13. Profile Options
14. FND Users
15. 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