Overview of FNDLOAD in R12.2

Overview of FNDLOAD in R12.2

 FNDLOAD is a Concurrent Program that allows the moving of Metadata from one instance to another instance.

The loader operates in one of two modes: download or upload. In the download mode, data is downloaded from the database to a text file. in the upload mode data is uploaded from a text file to the database. 

The Generic Loader downloads data from a database according to a configuration (.lct) file and converts the data into a data file (.ldt file). The Generic Loader can then upload this data to another database using a configuration file. 

It allows downloading of Metadata directly via a OS command and then can be moved and uploaded to another instance.

What is LCT and LDT files?

LCT:

Loader configuration file

LDT:

Loader data file format

Create .ldt files

Concurrent Program LDT

FNDLOAD apps/pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $JA_TOP/patch/115/import/US/jai121cp.ldt - CUSTOM_MODE=FORCE

Value set LDT

FNDLOAD apps/pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct
$JA_TOP/patch/115/import/US/PER_ORGANIZATION_UNITS_C.ldt

Function Upload LDT

FNDLOAD apps/pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct
$JA_TOP/patch/115/import/US/jai121apfn.ldt - CUSTOM_MODE=FORCE

Upload Message LDT

FNDLOAD apps/pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct
$JA_TOP/patch/115/import/US/jai121msg.ldt - CUSTOM_MODE=FORCE

Value Set

FNDLOAD apps/pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xx_file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=”value set name”

Value Set with values

FNDLOAD apps/pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xx_file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name”

Profile Option

FNDLOAD apps/pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct xx_file_name.ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”XX”

Function

FNDLOAD apps/ pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xx_file_name.ldt FUNCTION FUNC_APP_SHORT_NAME="XX" FUNCTION_NAME=”function_name“

Alert

FNDLOAD apps/ pwd 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct xx_file_name.ldt ALR_ALERTS APPLICATION_SHORT_NAME=”XX” ALERT_NAME=”Alert name”

Refer:

How to Upload the 'ldt' files Manually (Doc ID 1092694.1)