FNDLOAD

The loader syntax is as follows:


we have set environmental variable first

from admin folder run fndload. run envinomental variable from appl_top path  . ./*.env

To download rules for a particular function:

FNDLOAD apps/apps@DEV07 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct filename.ldt PROGRAM APPLICATION_SHORT_NAME=ar CONCURRENT_PROGRAM_NAME=XXAR_INVOICE
FNDLOAD / 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
FND_FORM_CUSTOM_RULES function_name=

Note: this style is not recommended, as the personalizations that affect a particular
function can now be a mix of function- and form-level rules.

To download rules for a particular form:

FNDLOAD / 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
FND_FORM_CUSTOM_RULES form_name=

To download all personalizations (all forms and functions):

FNDLOAD / 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
FND_FORM_CUSTOM_RULES

Upload:
FNDLOAD / 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct

************************************

FNDLOAD is stored in the path in the name of FNDLOAD.exe

Path: D:\oracle\prodappl\fnd\11.5.0\bin

Step: 1 Download the concurrent program in the local directory as .ldt file
To download concurrent program as .ldt file, you need afcpprog.lct (script file), which is in the path

Path: D:\oracle\prodappl\fnd\11.5.0\patch\115\import
Note: You have execute script, request set script etc., in that path.
This script file afcpprog.lct converts concurrent program to .ldt file.

Open Command Prompt:

Enter: D:\>cd oracle\prodappl\fnd\11.5.0\bin

Enter: D:\oracle\prodappl\fnd\11.5.0\bin>fndload

You have not provided the required arguments for this program.
Usage: FNDLOAD logon 0 Y mode configfile datafile [ entity [ param ... ] ]

Where
logon is username/password[@connect]

mode is either UPLOAD or DOWNLOAD

configfile is the configuration file,datafile is the data file entity is an entity name, or - to specify all values in an upload param is a NAME=VALUE string used for parameter substitution

Enter: D:\oracle\prodappl\fnd\11.5.0\bin>fndload apps/apps@prod 0 Y DOWNLOAD d:\oracle

\prodappl\fnd\11.5.0\patch\115\import\afcpprog.lct d:\tabular.ldt PROGRAM APPLICATION_SHORT_NAME="SQLAP" CONCURRENT_PROGRAM_NAME="TABULAR.PRG"

Log filename : L2770578.log
Report filename : O2770578.out

/*Copy the log filename after ‘type’ to see the download details */

Enter: D:\oracle\prodappl\fnd\11.5.0\bin>type L2770578.log

*********************************************************


D:\oracle\prodappl\fnd\11.5.0\bin>

Step: 2 Upload the concurrent program to other system.

Copy the .ldt code file and .rdf file to this system, here c:\tabular.ldt and D:\oracle\prodappl\ap\11.5.0\reports\US\ tabular.rdf

D:\>cd oracle\prodappl\fnd\11.5.0\bin
Enter: D:\oracle\prodappl\fnd\11.5.0\bin>fndload apps/apps@prod 0 Y UPLOAD d:\oracle\prodappl\
fnd\11.5.0\patch\115\import\afcpprog.lct c:\tabular.ldt

Log filename : L2753688.log
Report filename : O2753688.out

Enter: D:\oracle\prodappl\fnd\11.5.0\bin>type L2753688.log

***************************************



Uploading from the data file c:\tabular.ldt

Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (d:\oracle\prodappl\fnd\11.5.0\patch\115\import\afcpprog.lct(115.39), c:\tabular.ldt) to stage tables
Dump LCT file d:\oracle\prodappl\fnd\11.5.0\patch\115\import\afcpprog.lct(115.39) into FND_SEED_STAGE_CONFIG
Dump LDT file c:\tabular.ldt into FND_SEED_STAGE_ENTITY
No data found for upload ------> /*if error this message will be shown*/

*********************************************

Enter: D:\oracle\prodappl\fnd\11.5.0\bin>fndload apps/apps@prod 0 Y UPLOAD d:\oracle\prodappl\ fnd\11.5.0\patch\115\import\afcpprog.lct c:\jb.ldt

Log filename : L2753692.log
Report filename : O2753692.out



Enter: D:\oracle\prodappl\fnd\11.5.0\bin>type L2753692.log

***************************************

Uploading from the data file c:\jb.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (d:\oracle\prodappl\fnd\11.5.0\patch\115\import\afcpprog.lct(115.39), c:\jb.ldt) to stage tables
Dump LCT file d:\oracle\prodappl\fnd\11.5.0\patch\115\import\afcpprog.lct(115.39

) into FND_SEED_STAGE_CONFIG
Dump LDT file c:\jb.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE SAMPLE1 SQLAP , PROGRAM JB_SAMPLE1_PRG SQLAP ) into
FND_SEED_STAGE_ENTITY
Upload from stage tables ------->/* if it is correct*/

+---------------------------------------------------------------------------+

Concurrent request completed successfully
Current system time is 29-MAR-2008 16:52:39

+---------------------------------------------------------------------------+



D:\oracle\prodappl\fnd\11.5.0\bin>