[EBS] FNDLOAD Command

1. Printer Styles
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

2. Lookups
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND" LOOKUP_TYPE="lookup name"

3. Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL='COL_ALL:REF_ALL:CTX_ONE:SEG_ALL' APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"

4. Key Flexfield Structures
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL='COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL' APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

5. Concurrent Programs
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name"

6. Value Sets
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

7. Value Sets with values
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

8. Profile Options
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

9. Request Groups
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

10. Request Sets
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"

11. Responsibilities
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"

12. Menus
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"

13. Folder
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct file_name.ldt MENU MENU_NAME="menu_name"

FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct file_name.ldt FND_FOLDERS NAME="folder_name"

FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct file_name.ldt FND_FOLDERS OBJECT="object_name"

14. Form Customization
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES FUNCTION_NAME="PO_POXSCERQ"

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES FORM_NAME="PO_POXSCERQ"

FNDLOAD apps/apps 0 Y UPLOAD   $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt

15. Message
FNDLOAD apps/wjdql90 O Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct MSG_XXXTR.ldt FND_NEW_MESSAGES MESSAGE_NAME="XXXTR%"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct MSG_XXXTR.ldt

16. WebADI
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct bneNewMsgs.ldt BNE_INTEGRATORS INTEGRATOR_ASN=BNE INTEGRATOR_CODE=GENERAL_221_INTG

FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct bneNewMsgs.ldt BNE_INTEGRATORS INTEGRATOR_CODE=GENERAL_161_INTG

FNDLOAD apps/apps 0 Y DOWNLOAD bneintegrator.lct bneNewMsgs.ldt BNE_INTEGRATORS INTEGRATOR_ASN=BNE INTEGRATOR_CODE_LIST=FND_NEW_MESSAGES_INTG,JOURNALS_115

FNDLOAD apps/apps  0 Y UPLOAD   $BNE_TOP/patch/115/import/bneintegrator.lct bneNewMsgs.ldt


-----

References

• Oracle Application System Administrator's Guide Appendix C has detail description on the usage of loaders.
• Note: 247126.1 - How To Download Request Set Definition From One Instance And  Upload On Another Instance
• Note: 274667.1 - FNDLOAD Commands to Download Different Seed Data Types
• Note: 274528.1 - Note How To Download Single Context Using FNDLOAD For Descriptive Flexfield.
• Note: 256573.1 - How To Download/Upload Descriptive Flexfield With Name $SRS$.