Oracle Applications (Oracle E-Business Suite) use
Loader Data files (LDT files) for migrating application configurations and data
between instances.
What are LDT Files?
LDT files are plain text files used by the FNDLOAD utility
in Oracle E-Business Suite to upload or download data from the database. They
are commonly used for migrating setups, such as concurrent programs, value
sets, and lookups, across different environments.
LDT Commands:
1. Download
Data to LDT File
FNDLOAD apps/apps_pwd 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afcpprog.lct output_file.ldt FND_PROGRAM
APPLICATION_SHORT_NAME="Application_Short_Name"
CONCURRENT_PROGRAM_NAME="Program_Name"
2. Upload
Data from LDT File
FNDLOAD apps/apps_pwd 0 Y UPLOAD
$FND_TOP/patch/115/import/afcpprog.lct input_file.ldt
Key Parameters
- apps/apps_pwd:
The username and password for the Oracle Apps database.
- 0
Y: Standard flags for FNDLOAD (0 indicates no error checking, Y
indicates 'Yes' for upload/download).
- DOWNLOAD/UPLOAD:
The action to perform.
- $FND_TOP/patch/115/import/afcpprog.lct:
The location and name of the control file (LCT file) which defines the
data structure.
- output_file.ldt/input_file.ldt:
The LDT file to write to or read from.
- FND_PROGRAM:
The entity to download or upload.
- APPLICATION_SHORT_NAME:
The short name of the application.
- CONCURRENT_PROGRAM_NAME:
The name of the concurrent program.
Concurrent Program:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afcpprog.lct XXCUSTITEMCATASSIGN_P.ldt PROGRAM
APPLICATION_SHORT_NAME= "XXCUST"
CONCURRENT_PROGRAM_NAME="XXCUSTITEMCATASSIGN"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afcpprog.lct XXCUSTITEMCATASSIGN_P.ldt
Data Definition / Template:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$XDO_TOP/patch/115/import/xdotmpl.lct XXCUST_COST_SHEET_DTL_RPT_DD.ldt
XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME= "XXCUST"
DATA_SOURCE_CODE="XXCUST_COST_SHEET_DTL_RPT"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$XDO_TOP/patch/115/import/xdotmpl.lct XXCUST_COST_SHEET_DTL_RPT_DD.ldt
Lookups:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/aflvmlu.lct XXCUST_IMPREST_TYPE.ldt FND_LOOKUP_TYPE
APPLICATION_SHORT_NAME= "XXCUST"
LOOKUP_TYPE="XXCUST_IMPREST_TYPE"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/aflvmlu.lct XXCUST_IMPREST_TYPE.ldt
UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
Forms:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct XXCUST_PETTYCASH_ADV.ldt FORM
APPLICATION_SHORT_NAME= "XXCUST"
FORM_NAME="XXCUST_PETTYCASH_ADV"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afsload.lct XXCUST_PETTYCASH_ADV.ldt
Forms Function:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct XXCUST_PETTYCASH_ADV.ldt FUNCTION
FUNC_APP_SHORT_NAME= "XXCUST"
FUNCTION_NAME="XXCUST_PETTYCASH_ADV"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afsload.lct XXCUST_PETTYCASH_ADV.ldt
Form Personalization:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/affrmcus.lct XXCUST_APPR_LIST.ldt
FND_FORM_CUSTOM_RULES function_name="XXCUST_APPR_LIST"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/affrmcus.lct XXCUST_APPR_LIST.ldt
Messages:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afmdmsg.lct XXCUST_CHARGE_UPDATE_MESSAGE.ldt
FND_NEW_MESSAGES APPLICATION_SHORT_NAME= "XXCUST"
MESSAGE_NAME="XXCUST_CHARGE_UPDATE_MESSAGE"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afmdmsg.lct XXCUST_CHARGE_UPDATE_MESSAGE.ldt
Oracle Alerts:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$ALR_TOP/patch/115/import/alr.lct XXCUST_PETTYCASH_APPR_ADJ.ldt ALR_ALERTS
APPLICATION_SHORT_NAME= "XXCUST"
ALERT_NAME="XXCUST_PETTYCASH_APPR_ADJ"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$ALR_TOP/patch/115/import/alr.lct XXCUST_PETTYCASH_APPR_ADJ.ldt
Responsibility:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afscursp.lct XXCUST_CUSTOM_REPORTS.ldt
FND_RESPONSIBILITY RESP_KEY="XXCUST_CUSTOM_REPORTS"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afscursp.lct XXCUST_CUSTOM_REPORTS.ldt
Menus:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct XXCUST_CUST_PR_MENU.ldt MENU
MENU_NAME="XXCUST_CUST_PR_MENU"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afsload.lct XXCUST_CUST_PR_MENU.ldt
Value set:
Download Script
FNDLOAD apps/apps 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct XXCUSTL_OU_VS.ldt VALUE_SET
FLEX_VALUE_SET_NAME="XXCUSTL_OU"
Upload script
FNDLOAD apps/apps 0 Y UPLOAD
$FND_TOP/patch/115/import/afffload.lct XXCUSTL_OU_VS.ldt
Comments
Post a Comment