LDT Download/Upload Commands in Oracle Apps

1. To download Ldt file for a Concurent Program

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' CONCURRENT_PROGRAM_NAME='[Concurrent program Short Name]'       Above command downloads the executable information and Value Sets associated to the program.

2. To download Ldt file for a Data Definition

FNDLOAD [username]/[password] O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' DATA_SOURCE_CODE='[Data Definition Short Name]'       Above command downloads the template definition too.

3. To download Ldt file for a Request Set

FNDLOAD [username]/[password] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET REQUEST_SET_NAME='[REQUEST_SET_SHORT_NAME]'       Make sure we run the below command too.

4. To download Ldt file for a Request Set Links

FNDLOAD [username]/[password] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET_LINKS REQUEST_SET_NAME='[REQUEST_SET_SHORT_NAME]'

5. To download Ldt file for a Lookup Up

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' LOOKUP_TYPE='[LOOKUP_TYPE]'

6. To download Ldt file for a request group for a Concurrent Program

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME='[REQUEST_GROUP_NAME]' APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' REQUEST_GROUP_UNIT UNIT_APP='[UNIT_APPLICATION_SHORT_NAME]' UNIT_TYPE='P' UNIT_NAME='[Concurrent program Short Name]'

7. To download Ldt file for a request group for a Request Set

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME='[REQUEST_GROUP_NAME]' APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' REQUEST_GROUP_UNIT UNIT_APP='[UNIT_APPLICATION_SHORT_NAME]' UNIT_TYPE='S' UNIT_NAME='[Request Set Name]'

8. To download Ldt file for a Value Set

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME='[VALUE_SET_NAME]'

9. To download Ldt file for a Value Set with values

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME='[VALUE_SET_NAME]'

10. To download Ldt file for a DFF

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' DESCRIPTIVE_FLEXFIELD_NAME='[flex field Name]' P_CONTEXT_CODE='[Context Code]'

11. To download Ldt file for a DFF for a particular attribute column

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' DESCRIPTIVE_FLEXFIELD_NAME='[flex field Name]' DESCRIPTIVE_FLEX_CONTEXT_CODE='[Context Code]' END_USER_COLUMN_NAME='[Attribute Column Name]' APPLICATION_COLUMN_NAME='[attribute column number]'

12. To download Ldt file for a profile Option

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME='[PROFILE_OPTION_NAME]' APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]'

13. To download Ldt file for a Audit Group

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/affaudit.lct file_name.ldt FND_AUDIT_GROUPS APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' GROUP_NAME = '[Audit Group Name]'

14. To download Ldt file for a Audit Schema

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/affaudit.lct file_name.ldt FND_AUDIT_SCHEMAS ORACLE_USERNAME='ORACLE_USERNAME' APPLICATION_SHORT_NAME='APPLICATION_SHORT_NAME'

15. To download Ldt file for a Responsibility

FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="[Responsibility Name]" 1. To upload Ldt file for a Concurent Program FNDLOAD [username]/[password]' O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt 2. To upload Ldt file for a Data Definition FNDLOAD [username]/[password] O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt 3. To upload Ldt file for a Request Set FNDLOAD [username]/[password] 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt 4. To upload Ldt file for a Request Set Links FNDLOAD [username]/[password] 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt 5. To upload Ldt file for a Lookup Up FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt 6. To upload Ldt file for a request group for a Concurrent Program FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt 7. To upload Ldt file for a request group for a Request Set FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt 8. To upload Ldt file for a Value Set FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt 9. To upload Ldt file for a Value Set with values FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt 10. To upload Ldt file for a DFF FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt 11. To upload Ldt file for a DFF for a particular attribute column FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt 12. To upload Ldt file for a profile Option FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt 13. To upload Ldt file for a Audit Group FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/affaudit.lct file_name.ldt 14. To upload Ldt file for a Audit Schema FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/affaudit.lct file_name.ldt 15. To upload Ldt file for a Responsibility FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt