Transfer Concurrent Program Definitions - FNDLOAD

1) Log into the UNIX box
2) Go to $FND_TOP/patch/115/import/
3) Verify that the control file (lct) is in this directory – in the case of the concurrent program load it is afcpprog.lct
NOTE: Obviously you can do the execution from a different directory, e.g. there is US directory under the import directory, but I chose to keep it simple and do it under the import directory
4) Type FNDLOAD apps/simple4u@dfrwei 0 Y DOWNLOAD afcpprog.lct prog.ldt PROGRAM APPLICATION_SHORT_NAME=XBOL
5) FTP the ldt file to the server it is to be uploaded to
6) Upload the file in this order:
FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct prog.ldt EXECUTABLE APPLICATION_SHORT_NAME=XBOL LANGUAGE=US

FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct prog.ldt VALUE_SET APPLICATION_SHORT_NAME=XBOL LANGUAGE=US

FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct prog.ldt VSET_TABLE APPLICATION_SHORT_NAME=XBOL LANGUAGE=US

FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct prog.ldt DESC_FLEX APPLICATION_SHORT_NAME=XBOL LANGUAGE=US

FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct prog.ldt PROGRAM APPLICATION_SHORT_NAME=XBOL LANGUAGE=US
7) That’s it – verify that the load worked by reviewing the log file and the application
NOTE: It would only allow me to upload once per session; if I log into UNIX with the terminal emulator and run upload it will not allow me to run upload again… I have to log out of UNIX and log back in. I’m sure this is a setting at the UNIX or terminal emulator that I was missing.
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ... ]

Parameter
Use

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

The configuration file to use (usually with a suffix of .lct, but not enforced or supplied by the loader).

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.

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.



Concurrent Program Configuration File
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.

Entity
Sub–entities, if any
Download Parameters
PROGRAM
INCOMPATIBILITY
CONCURRENT_PROGRAM_NAME, APPLICATION_SHORT_NAME
EXECUTABLE

EXECUTABLE_NAME




cd $FND_TOP/patch/115/import

cp credit.ldt /interface/inffrwei/TFRWEI/incoming/

cp /interface/inffrwei/TFRWEI/incoming/credit.ldt credit.ldt


FNDLOAD apps/simple4u@dfrwei 0 Y DOWNLOAD afcpprog.lct credit.ldt PROGRAM CONCURRENT_PROGRAM_NAME=FRWECRDSUM


FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct credit.ldt EXECUTABLE CONCURRENT_PROGRAM_NAME=FRWECRDSUM LANGUAGE=US

cd $FND_TOP/patch/115/import

FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct credit.ldt VALUE_SET CONCURRENT_PROGRAM_NAME=FRWECRDSUM LANGUAGE=US

exit

cd $FND_TOP/patch/115/import

FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct credit.ldt VSET_TABLE CONCURRENT_PROGRAM_NAME=FRWECRDSUM LANGUAGE=US

exit

cd $FND_TOP/patch/115/import

FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct credit.ldt DESC_FLEX CONCURRENT_PROGRAM_NAME=FRWECRDSUM LANGUAGE=US

exit

cd $FND_TOP/patch/115/import

FNDLOAD apps/simple4u@tfrwei 0 Y UPLOAD_PARTIAL afcpprog.lct credit.ldt PROGRAM CONCURRENT_PROGRAM_NAME=FRWECRDSUM LANGUAGE=US

exit