How to use FNDLOAD to extract ldt file for specific Context of DFF?
<<-- Basics of FNDLOAD -->
Let us understand the basics before I reveal the command. FNDLOAD is nothing but a concurrent program. The concurrent executable takes the following parameters:
FNDLOAD apps/pwd
FNDLOAD apps/pwd
0 Y
mode
configfile
datafile
entity
[ param ...]
Here let us see the importance of each parameter one by one..
Ø 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.
using the name TWO_TASK.
Ø 0 Y - Concurrent program flags.
Ø mode - UPLOAD or DOWNLOAD. UPLOAD causes the datafile to be uploaded to the database. DOWNLOADcauses the loader to fetch rows and write them to the datafile.
Ø configfile - The configuration file to use (usually with a suffix of .lct, but not enforced or supplied by the loader).
Ø datafile - 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.
<-- Command to extract ldt file for specific context -->
FNDLOAD $usrname/$Passwd
O Y
DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct
file_name.ldt
DESC_FLEX APPLICATION_SHORT_NAME=”FND”
DESCRIPTIVE_FLEXFIELD_NAME=”FND_FLEX_VALUES”
DFF_CONTEXT DESCRIPTIVE_FLEX_CONTEXT_CODE="XX_CONTEXT_NAME"
Note: if we missed out any parameters, by default it will give for all the subentities, instead of a specific subentity
No comments:
Post a Comment