add

About Me

My photo
Oracle Apps - Techno Functional consultant

Sunday, March 11

FNDLOAD Usage


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.

<congle>
The configuration file to use (usually with a suffix of .lct, but not enforced or supplied by the loader).

<datale>
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"

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"

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

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 .

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 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"

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"

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"

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"

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"

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.
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"
 
 1 - Printer Styles
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt

2 - Lookups
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt

3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.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

5 - Concurrent Programs
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt

6 - Value Sets
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.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

8 - Profile Options
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt

9 - Request Groups
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt

10 - Request Sets
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.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

12 - Menus
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afsload.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

No comments: