Creating LDT files in Oracle Apps

• LDT is a file extension for a data file used with Oracle  applications.
• LDT stands for Loader DaTa files.
• LDT files contain entity definitions, parent-child relationships, input parameters and data. LDT files to an LCT file which is used for the configuration.
• LDT files can be exported from the Oracle database using the FNDLOAD function.
• We can open and edit LDT files, but it is not a recommended way.

We can create LDT files for following things:

1. PROFILE Options
2. Forms
3. FUNCTIONS
4. Menus
5. Responsibilities
6. Request GROUPS
7. Request SETS
8. Lookups
9. VALUE SETS
10. Descriptive flex-FIELDS
11. KEY flex-FIELDS
12. Concurrent programs
13. Form personalization
14. FND USERS
15. Alerts

Profile Options:

SOURCE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XXPRNAME.ldt
PROFILE PROFILE_NAME="XXPRNAME" APPLICATION_SHORT_NAME="PN"

Target:
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XXPRNAME.ldt
FNDLOAD apps/apps 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afscprof.lct XXPRNAME.ldt PROFILE PROFILE_NAME=" XXPRNAME" APPLICATION_SHORT_NAME="PN"

Forms:

SOURCE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFRMNAME.ldt FORM APPLICATION_SHORT_NAME="PN" FORM_NAME="XXFRMNAME"

Target:
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afsload.lct XXFRMNAME.ldt

Functions:

SOURCE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFUNNAME.ldt FUNCTION FUNC_APP_SHORT_NAME="PN" FUNCTION_NAME="XXFUNNAME"

Target:
FNDLOAD apps/apps O Y UPLOAD @FND:patch/115/import/afsload.lct XXFUNNAME.ldt

Note : apps/apps is Database UserName/PassWord

Continue>>>