FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ... ]
where
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.
<> Concurrent program flags
mode 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.
supplied by the loader).
the loader). If the data file already exists, it will be overwritten.
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.
Syntax
=======
An example of downloading is:
----------------------------
FNDLOAD apps/apps@TEST 0 Y DOWNLOAD testcfg.lct out.ldt FND_APPLICATION_TL APPSNAME=FND
This command does the following:
connects to apps/apps@devd
downloads data using the configuration file testcfg.lct
writes data to data file out.ldt
downloads the FND_APPLICATION_TL entity with APPSNAME parameter defined as value FND’
An example of uploading is:
--------------------------
FNDLOAD apps/apps@custdb 0 Y UPLOAD fndapp.lct fnd_exmpl.ldt
This command does the following:
connects to apps/apps@custdb
uploads data using the configuration file in fndapp.lct from datafile in fnd_exmpl
The contents of the entire data file is uploaded.
FNDLOAD Load Options
---------------------
Application level OR single entity level download
Entire OR Partial upload of a data file
Custom mode force update
Support for NLS uploads
AOL ENTITIES
-------------
FNDLOAD an be used for the below Application entities.
Concurrent program definitions
Request groups,Request Sets,Lookup types and lookup values,Profile options and profile option values
Flexfields setup data,Flexfield Value Sets,Descriptive Flexfields,Key Flexfields
Flexfield Value Security Rules,Flexfields Value Hierarchies (Rollup Groups),Flexfields Values,Attachments definitions
Messages,Menus,Responsibilities,,Security information,Etc..
Examples:
========
A)Concurrent Program Definitions:
---------------------------------
The concurrent program configuration file afcpprog.lct downloads and uploads concurrent program definitions. It takes as parameters program name and application name. The following table lists the entities, sub-entities (if any), and download parameters for this configuration file.
Download
-----------
FNDLOAD apps/apps@db O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="prod" CONCURRENT_PROGRAM_NAME="concurrent name"
Upload
-----------
FNDLOAD apps/apps@db O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt
B)Request Groups Configuration File:
------------------------------------
Use the file afcpreqg.lct for loading request group data. The following table lists the entities, sub–entities (if any), and download parameters for this configuration file.
Download
---------
FNDLOAD apps/apps@db O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="prod"
Upload
------
FNDLOAD apps/apps@db O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt
C)Request Sets Configuration File
----------------------------------
Use the file afcprset.lct for loading request group data. The following table lists the entities, sub–entities (if any), and download parameters for this configuration file.
Download
---------
FNDLOAD apps/apps@db O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME="prod" REQUEST_SET_NAME="request set"
Upload
---------
FNDLOAD apps/apps@db O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt
D)Lookups Configuration File
----------------------------
Use the file aflvmlu.lct for loading Lookup types and Lookups values. The following table lists the entities, sub–entities (if any), and download parameters for this configuration file.
Download
---------
FNDLOAD apps/apps@db O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="prod" LOOKUP_TYPE="lookup name"
Upload
-----
FNDLOAD apps/apps@db O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt
E)Profile Options and Profile Values Configuration File:
-------------------------------------------------------
Use the file afscprof.lct for loading profile options and profile values. The following table lists the entities, sub–entities (if any), and download parameters for this configuration file.
Download
---------
FNDLOAD apps/apps@db O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="prod"
Upload
---------
FNDLOAD apps/apps@db O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt
F)Flexfield Value Sets:
----------------------
The entity VALUE_SET includes the following table details of table validated value sets, and user exit details of special/pair validated value sets. It does not include the values, security rules, rollup groups, or value hierarchies for the value set. These entities should be
downloaded and uploaded separately.
The key for this entity is FLEX_VALUE_SET_NAME.
Download
---------
FNDLOAD apps/apps@db O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"
Upload
---------
FNDLOAD apps/apps@db O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
G)Responsibilities Configuration File:
-------------------------------------
Use the file afscursp.lct for downloading and uploading forms, functions, menus, and menu entries. The following table lists the entities, sub–entities (if any), and download parameters for this configuration file.
Download
---------
FNDLOAD apps/apps@db O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"
Upload
---------
FNDLOAD apps/apps@db O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt
Program
Name
|
|
Concurrent Program
|
|
Request Groups
|
|
Request Sets
|
|
Lookups
|
FNDLOAD apps/apps@db
O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct
file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="prod" LOOKUP_TYPE="lookup
name"
|
Profile Options
|
FNDLOAD apps/apps@db
O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct
file_name.ldt PROFILE PROFILE_NAME="profile
option" APPLICATION_SHORT_NAME="prod"
|
Value Sets
|
|
Descriptive Flexfield
|
FNDLOAD apps/apps@db
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="prod" DESCRIPTIVE_FLEXFIELD_NAME="desc
flex name" P_CONTEXT_CODE="context name"
|
Key Flexfield
|
FNDLOAD apps/apps@db
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="prod" ID_FLEX_CODE="key flex
code" P_STRUCTURE_CODE="structure name"
|
Value Sets with values
|
FNDLOAD apps/apps@db
O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set
name"
|
Messages
|
FNDLOAD apps/apps@db
0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct file_name.ldt
FND_NEW_MESSAGES APPLICATION_SHORT_NAME='prod'
MESSAGE_NAME='message
name'
|
Menus
|
FNDLOAD apps/apps@db
O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU
MENU_NAME="menu_name"
|
Responsibilities
|
FNDLOAD apps/apps@db
O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct
file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"
|
Printer Styles
|
FNDLOAD apps/apps@db
O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct
file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"
|
Spread Table
|
FNDLOAD apps/apps@db
0 Y DOWNLOAD $FND_TOP/patch/115/import/jtfgrid.lct
IEX_CASE.ldt JTF_GRID_DATASOURCES GRID_DATASOURCE_NAME="IEX_CASE"
|
Program
name
|
|
Concurrent Program
|
|
Request Groups
|
|
Request Sets
|
|
Lookups
|
|
Profile Options
|
FNDLOAD apps/apps@db
O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt
|
Value Sets
|
|
Descriptive Flexfield
|
FNDLOAD apps/apps@db
O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
|
Key Flexfield
|
FNDLOAD apps/apps@db
O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
|
Value Sets with values
|
FNDLOAD apps/apps@db
O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
|
Messages
|
FNDLOAD apps/apps@db
0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct file_name.ldt
|
Menus
|
FNDLOAD apps/apps@db
O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt
|
Responsibilities
|
FNDLOAD apps/apps@db
O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt
|
Printer Styles
|
FNDLOAD apps/apps@db
O Y UPLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt
|
Spread Table
|
FNDLOAD apps/apps@db
0 Y UPLOAD $FND_TOP/patch/115/import/jtfgrid.lct IEX_CASE.ldt
|
No comments:
Post a Comment