fndload examples

fndload examples

-- Concurrent Program Download
FNDLOAD apps/fndkis O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXAR_ARXCRR.ldt PROGRAM APPLICATION_SHORT_NAME="XXAR" CONCURRENT_PROGRAM_NAME="XXAR_ARXCRR"
-- Concurrent Program Upload
FNDLOAD apps/c0l0rad0 O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXAR_ARXCRR.ldt PROGRAM APPLICATION_SHORT_NAME="XXAR" CONCURRENT_PROGRAM_NAME="XXAR_ARXCRR"

-- Request Group Download
FNDLOAD apps/fndkis O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct CUSTOM_CE_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME="Custom Cash Management" APPLICATION_SHORT_NAME="XXCE"
-- Request Group Upload
FNDLOAD apps/c0l0rad0 O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct CUSTOM_CE_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME="Custom Cash Management" APPLICATION_SHORT_NAME="XXCE"

-- Request Set Download
FNDLOAD apps/fndkis O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct CUSTOM_MASS_ADDITIONS_RS.ldt REQ_SET APPLICATION_SHORT_NAME="OFA" REQUEST_SET_NAME="FNDRSSUB1298"
-- Request Set Upload
FNDLOAD apps/c0l0rad0 O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct CUSTOM_MASS_ADDITIONS_RS.ldt REQ_SET APPLICATION_SHORT_NAME="OFA" REQUEST_SET_NAME="FNDRSSUB1298"

-- Menu Download
FNDLOAD apps/fndkis O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXCE_SUPERUSER.ldt MENU MENU_NAME="XXCE_SUPERUSER"
-- Menu Upload
FNDLOAD apps/c0l0rad0 O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXCE_SUPERUSER.ldt MENU MENU_NAME="XXCE_SUPERUSER"

-- Responsibility Download
FNDLOAD apps/fndkis O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XXCE_CUSTOM_CASH_MANAGEMENT.ldt FND_RESPONSIBILITY RESP_KEY="XXCE_CUSTOM_CASH_MANAGEMENT"
-- Responsibility Upload
FNDLOAD apps/c0l0rad0 O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXCE_CUSTOM_CASH_MANAGEMENT.ldt FND_RESPONSIBILITY RESP_KEY="XXCE_CUSTOM_CASH_MANAGEMENT"

Metalink note on FNDLOAD

============================================

Applies to:

Oracle Application Object Library - Version: 11.5.9
Information in this document applies to any platform.

Goal

How to download different seed data types?

Solution

The Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application entity data between database and text file.The loader reads a configuration file to determine which entity to access.
1 - Printer Styles
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"
2 - Lookups
FNDLOAD apps/apps 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/apps 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"
Examples:
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$.
4 - Key Flexfield Structures
FNDLOAD apps/apps 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/apps 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/apps 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/apps 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/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"
8 - Request Groups
FNDLOAD apps/apps 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/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET
APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"
Examples:
Note <247126.1> - How To Download Request Set Definition From One Instance And Upload On Another Instance
11 - Responsibilities
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"
12 - Menus
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"
: Oracle Application System Administrator's Guide Appendix C has detail description on the usage of loaders.