1 FNDLOAD Description
Generic Loader
The Generic Loader (FNDLOAD) is a concurrent program that can move Oracle Applications data between database and text file representations. The loader reads a configuration file to determine what data to access. For information on specific configuration files consult the Open Interfaces Guide for your product group. The following sections describe the operation of the Generic Loader.
Warning: Use only the loader files provided by Oracle Applications. If you use files not provided by Oracle Applications or modify the provided scripts you risk corrupting your database. Oracle does not support the use of custom loader files or modified Oracle Applications loader files.
FNDLOAD Executable
The Generic Loader is a concurrent program named FNDLOAD. The concurrent executable takes the following parameters: FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ...] Where
<apps/pwd>
The APPS schema and password in the form username/password[@connect_string]. If connect_string is omitted, it is taken in a platform-specific manner from the environment using the name TWO_TASK.
< 0 Y >
Concurrent program flags UPLOAD or DOWNLOAD. UPLOAD causes the datafile to be uploaded to the database. DOWNLOAD causes the loader to fetch rows and write them to the datafile.
<congle>
The configuration file to use (usually with a suffix of .lct, but not enforced or supplied by the loader).
<datale>
The data file to write (usually with a suffix of .ldt, but not enforced or supplied by the loader). If the data file already exists, it will be overwritten.
<entity>
The entity(ies) to upload or download. When uploading, you should always upload all entities, so specify a "-" to upload all entities.
< [param] >
Zero or more additional parameters are used to provide bind values in the access SQL (both UPLOAD and DOWNLOAD). Each parameter is in the form NAME=VALUE. NAME should not conflict with an attribute name for the entities being loaded.
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"
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"
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"
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"
Downloading 'Global Data Element' and all context codes that start with JA for all Descriptive Flexfields that starts with JG.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="JG" DESCRIPTIVE_FLEXFIELD_NAME="JG%"
P_LEVEL="COL_ALL:REF_ALL:CTX_ONE" P_CONTEXT_CODE="JA%"
Downloading 'Global Data Element’ and context codes is specifically LOCATION1 for Descriptive Flexfield HR_LOCATIONS.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="PER" DESCRIPTIVE_FLEXFIELD_NAME="HR_LOCATIONS" P_CONTEXT_CODE="LOCATION1"
P_LEVEL="COL_ALL:REF_ALL:CTX_ONE:SEG_ALL"
Uploading the .ldt file
$ FNDLOAD apps/password 0 Y UPLOAD @FND:patch/115/import/afffload.lct output.ldt
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="JG" DESCRIPTIVE_FLEXFIELD_NAME="JG%"
P_LEVEL="COL_ALL:REF_ALL:CTX_ONE" P_CONTEXT_CODE="JA%"
Downloading 'Global Data Element’ and context codes is specifically LOCATION1 for Descriptive Flexfield HR_LOCATIONS.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="PER" DESCRIPTIVE_FLEXFIELD_NAME="HR_LOCATIONS" P_CONTEXT_CODE="LOCATION1"
P_LEVEL="COL_ALL:REF_ALL:CTX_ONE:SEG_ALL"
Uploading the .ldt file
$ FNDLOAD apps/password 0 Y UPLOAD @FND:patch/115/import/afffload.lct output.ldt
How To Download/Upload Descriptive Flexfields With Name $SRS$ Using FNDLOAD
To download:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct \
/Your_path/SRS.ldt DESC_FLEX
To upload:
FNDLOAD apps/apps 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afcpprog.lct \
/Your_path/SRS.ldt DESC_FLEX .
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct \
/Your_path/SRS.ldt DESC_FLEX
To upload:
FNDLOAD apps/apps 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afcpprog.lct \
/Your_path/SRS.ldt DESC_FLEX .
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"
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"
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 FLEX_VALUE_SET_NAME="value set name"
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"
7 - Value Sets with values
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"
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"
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"
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"
9 - 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"
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"
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"
Download Request Set definitions (Using Entity "REQ_SET")
$FNDLOAD sqllogon 0 Y DOWNLOAD @FND:patch/115/import/afcprset.lct <sample>.ldt REQ_SET REQUEST_SET_NAME="<Request_Set_Name>"
Usage of entity "REQ_SET" with FNDLOAD will download request definitions of <Request_Set_Name> into <sample>.ldt using information in afcprset.lct Check the version of afcprset.lct that is compatible with your FND Patchset Level.
Example, use afcprset.lct 115.21 in case of Applications version 11.5.8
Download Request Set Stage links information. (Using Entity "REQ_SET_LINKS")
$FNDLOAD sqllogon 0 Y DOWNLOAD @FND:patch/115/import/afcprset.lct <sample_links>.ldt REQ_SET_LINKS REQUEST_SET_NAME="<Request_Set_Name>"
Usage of entity "REQ_SET_LINKS" with FNDLOAD will download request stage linkage information of <Request_Set_Name> into <sample_links>. ldt using information in afcprset.lct .Check the version of afcprset.lct that is compatible with your FND Patchset Level.
Now,use the resultant files <sample>.ldt and <sample_links>.ldt for uploading the Request Set data in another Instance, by using the commands given below int he following sequence :-
Upload Request Set definitions.
$FNDLOAD apps/<apps_pwd> 0 Y UPLOAD @FND:patch/115/import/afcprset.lct &
lt;sample>.ldt
Upload Request Set Stage links information.
$FNDLOAD apps/<apps_pwd> 0 Y UPLOAD @FND:patch/115/import/afcprset.lct &
lt;sample_links>.ldt
All the required Concurrent Program definitions should exist before loading the Request Set on the Target Instance.
11 - Responsibilities
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"
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"
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.
Descriptive Flexfield has many context code based on the value of reference field and there is a need of downloading specific Context and then upload to other instance.
Downloading 'Global Data Element' and all context codes that start with JA for all Descriptive Flexfields that starts with JG.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt
DESC_FLEX APPLICATION_SHORT_NAME="JG" DESCRIPTIVE_FLEXFIELD_NAME="JG%"
P_LEVEL="COL_ALL:REF_ALL:CTX_ONE" P_CONTEXT_CODE="JA%"
Downloading 'Global Data Element’ and context codes is specifically LOCATION1 for Descriptive Flexfield HR_LOCATIONS.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="PER" DESCRIPTIVE_FLEXFIELD_NAME="HR_LOCATIONS" P_CONTEXT_CODE="LOCATION1"
P_LEVEL="COL_ALL:REF_ALL:CTX_ONE:SEG_ALL"
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt
DESC_FLEX APPLICATION_SHORT_NAME="JG" DESCRIPTIVE_FLEXFIELD_NAME="JG%"
P_LEVEL="COL_ALL:REF_ALL:CTX_ONE" P_CONTEXT_CODE="JA%"
Downloading 'Global Data Element’ and context codes is specifically LOCATION1 for Descriptive Flexfield HR_LOCATIONS.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="PER" DESCRIPTIVE_FLEXFIELD_NAME="HR_LOCATIONS" P_CONTEXT_CODE="LOCATION1"
P_LEVEL="COL_ALL:REF_ALL:CTX_ONE:SEG_ALL"
3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
UPLOAD 'Global Data Element' and all context codes that start with JA for all Descriptive Flexfields that starts with JG.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt
Upload 'Global Data Element’ and context codes is specifically LOCATION1 for Descriptive Flexfield HR_LOCATIONS.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct output.ldt
How to Upload Descriptive Flexfields with Name $SRS$ Using FNDLOAD
FNDLOAD apps/apps 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afcpprog.lct SRS.ldt DESC_FLEX .
4 - Key Flexfield Structures
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
5 - Concurrent Programs
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt
7 - Value Sets with values
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
8 - Profile Options
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt
Upload Request Set definitions (Using Entity "REQ_SET")
$FNDLOAD sqllogon 0 Y UPLOAD @FND:patch/115/import/afcprset.lct <sample>.ldt
Upload Request Set Stage links information. (Using Entity "REQ_SET_LINKS")
$FNDLOAD sqllogon 0 Y UPLOAD @FND:patch/115/import/afcprset.lct <sample_links>.ldt
Upload Request Set definitions.
$FNDLOAD apps/<apps_pwd> 0 Y UPLOAD @FND:patch/115/import/afcprset.lct &
lt;sample>.ldt
Upload Request Set
Stage links information.
$FNDLOAD apps/<apps_pwd> 0 Y UPLOAD @FND:patch/115/import/afcprset.lct &
lt;sample_links>.ldt
All the required Concurrent Program definitions should exist before loading the Request Set on the Target Instance.
11 - Responsibilities
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt
UPLOAD 'Global Data Element' and all context codes that start with JA for all Descriptive Flexfields that starts with JG.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt
UPLOAD 'Global Data Element’ and context codes is specifically LOCATION1 for Descriptive Flexfield HR_LOCATIONS.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct output.ldt
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt
UPLOAD 'Global Data Element’ and context codes is specifically LOCATION1 for Descriptive Flexfield HR_LOCATIONS.
$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct output.ldt
No comments:
Post a Comment