Thursday, June 19, 2025

Oracle FNDLOAD and Examples

Reference

Most of its contents were taken from 'Dibyajyoti Koch: A Blog on Oracle Application' website but were modified for my own personal use. Please visit https://imdjkoch.wordpress.com/tag/fndload for its original contents along with many other useful ones.

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

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"
  • Upload
FNDLOAD apps/$pswd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CONC_PROG.ldt
  • 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'
  • 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
FNDLOAD apps/$pswd



No comments: