Loading

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
                   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. 
Ø      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

0 Responses to “FNDLOAD for CONCURRENT PROGRAMS”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.