Oracle FNDLOAD : Sample Syntax
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ...]
<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, 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.
Note: Objects enclosed in [ ] are optional and may be used for more precise download or upload.
Some Sample Examples:
FNDLOAD Concurrent Program
Download:
FNDLOAD apps/password O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct your_output_dir/your_name.ldt PROGRAM [APPLICATION_SHORT_NAME=$app] CONCURRENT_PROGRAM_NAME="SHORT_PROGRAM_NAME"
Upload:
FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct
your_output_dir/your_name.ldt
FNDLOAD Profile Options
Download
FNDLOAD apps/password O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct your_output_dir/your_name.ldt PROFILE PROFILE_NAME="profile_option_short_name"[APPLICATION_SHORT_NAME=app]
Upload
FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct your_output_dir/your_name.ldt
FNDLOAD Value Set
Download
FNDLOAD apps/password O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct your_output_dir/your_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value_set_name"
Upload
FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct your_output_dir/your_name.ldt
FNDLOAD Request Group
Download
FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct your_output_dir/your_name.ldt REQUEST_GROUP REQUEST_GROUP_CODE="REQUEST_GROUP_CODE"
Upload
FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct your_output_dir/your_name.ldt
FNDLOAD Request Set
Download
FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct your_output_dir/your_name.ldt REQ_SET REQUEST_SET_NAME="REQUEST_SET_NAME"
Upload
FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct your_output_dir/your_name.ldt
FNDLOAD Responsibility
Download
FNDLOAD Printer Style
Download:
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ...]
<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, 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.
Note: Objects enclosed in [ ] are optional and may be used for more precise download or upload.
Some Sample Examples:
FNDLOAD Concurrent Program
Download:
FNDLOAD apps/password O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct your_output_dir/your_name.ldt PROGRAM [APPLICATION_SHORT_NAME=$app] CONCURRENT_PROGRAM_NAME="SHORT_PROGRAM_NAME"
Upload:
FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct
your_output_dir/your_name.ldt
FNDLOAD Profile Options
Download
FNDLOAD apps/password O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct your_output_dir/your_name.ldt PROFILE PROFILE_NAME="profile_option_short_name"[APPLICATION_SHORT_NAME=app]
Upload
FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct your_output_dir/your_name.ldt
FNDLOAD Value Set
Download
FNDLOAD apps/password O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct your_output_dir/your_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value_set_name"
Upload
FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct your_output_dir/your_name.ldt
FNDLOAD Request Group
Download
FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct your_output_dir/your_name.ldt REQUEST_GROUP REQUEST_GROUP_CODE="REQUEST_GROUP_CODE"
Upload
FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct your_output_dir/your_name.ldt
FNDLOAD Request Set
Download
FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct your_output_dir/your_name.ldt REQ_SET REQUEST_SET_NAME="REQUEST_SET_NAME"
Upload
FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct your_output_dir/your_name.ldt
FNDLOAD Responsibility
Download
FNDLOAD apps/password 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afscursp.lct your_output_dir/your_name.ldt
FND_RESPONSIBILITY RESP_KEY="RESPONSIBILITY_KEY_VALUE"
Upload
FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct your_output_dir/your_name.ldt
FNDLOAD User Record
Download
FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct your_output_dir/your_name.ldt FND_USER USER_NAME="USERNAME_TO_PROCESS"
Upload
FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct your_output_dir/your_name.ldt
FNDLOAD Message
Download
Upload
FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct your_output_dir/your_name.ldt
FNDLOAD User Record
Download
FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct your_output_dir/your_name.ldt FND_USER USER_NAME="USERNAME_TO_PROCESS"
Upload
FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct your_output_dir/your_name.ldt
FNDLOAD Message
Download
FNDLOAD apps/password 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afmdmsg.lct your_output_dir/your_name.ldt
FND_NEW_MESSAGES APPLICATION_SHORT_NAME='app'
[MESSAGE_NAME="MESSAGE_NAME"]
Upload
Upload
FNDLOAD apps/password 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afmdmsg.lct your_output_dir/your_name.ldt
FNDLOAD Menu
Download
FNDLOAD Menu
Download
FNDLOAD apps/appspwd 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU
MENU_NAME="MENU_NAME"
Upload
FNDLOAD apps/appspwd 0 Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct file_name.ldt
FNDLOAD Printer Style
Download:
FNDLOAD apps/password O Y DOWNLOAD
$FND_TOP/patch/115/import/afcppstl.lct your_output_dir/your_name.ldt STYLE
PRINTER_STYLE_NAME="PRINTER_STYLE_NAME"
Upload:
FNDLOAD apps/password O Y UPLOAD
$FND_TOP/patch/115/import/afcppstl.lctUpload:
Short and Simple, this was helpful ...Thanks
ReplyDeleteHemanth