Friday, October 22, 2010
FNDLOAD for CONCURRENT PROGRAMS
<<-- 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. DOWNLOAD causes 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.
<-- Shell Script to DOWNLOAD ldt file for the specific concurrent program -->
echo "Enter Concurrent Program Short Name : \c"
read CONC_SHT_NAME
echo "Enter Concurrent Program Application Short Name : \c"
read APPL_CONC_SHT_NAME
stty -echo
echo "Enter APPS Password : \c"
read APPS_PASSWORD
stty echo
FNDLOAD 'APPS'/$APPS_PASSWORD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct "$CONC_SHT_NAME.ldt" PROGRAM APPLICATION_SHORT_NAME=$APPL_CONC_SHT_NAME CONCURRENT_PROGRAM_NAME=$CONC_SHT_NAME
<-- Shell Script to UPLOAD ldt file for the specific concurrent program -->
echo "Enter APPS User ID : \c"
read APPS_USER_ID
stty -echo
echo "Enter APPS Password : \c"
read APPS_PASSWORD
stty echo
echo "Enter ldt File name with path : \c"
read XXFILENAME
FNDLOAD $APPS_USER_ID/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $XXFILENAME
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “FNDLOAD for CONCURRENT PROGRAMS”
Post a Comment