Creating LDT files in Oracle Apps

Creating LDT files in Oracle Apps, www.askhareesh.com
  • 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







*/