April 14, 2015

FNDLOAD UPLOAD(RTF,XSL),DOWNLOAD

Create the concurrent program.to move you need to extract the ldt and upload the same through the script for nay other instance.Below have listed the commands used to download and upload of concurrent programs.

FNDLOAD command for Download

Concurrent:
FNDLOAD username/Password O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct FILENAME.ldt PROGRAM APPLICATION_SHORT_NAME="HR" CONCURRENT_PROGRAM_NAME="FILENAME"

Valueset:
FNDLOAD username/Password O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct SETNAME.ldt VALUE_SET FLEX_VALUE_SET_NAME="SETNAME"

Data Def:

FNDLOAD username/Password O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct FILENAME.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='HR' DATA_SOURCE_CODE='SHORTNAME' TMPL_APP_SHORT_NAME='HR' TEMPLATE_CODE='SHORTNAME'

Copy the rtf rdf and xsl file in local temp folder-dont download those.
UPLOAD:

Value Set:
$FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct  LOV.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Conc Prog:
$FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct  FILENAME.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

RTF:
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $APPS_LOGIN -DB_PASSWORD $APPS_PWD -JDBC_CONNECTION $APPSJDBC -LOB_TYPE TEMPLATE -APPS_SHORT_NAME HR -CUSTOM_MODE FORCE -XDO_FILE_TYPE RTF -LANGUAGE en -LOB_CODE SHORTNAME -FILE_NAME FILENAME.rtf

XSL:
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $APPS_LOGIN -DB_PASSWORD $APPS_PWD -JDBC_CONNECTION $APPSJDBC -LOB_TYPE TEMPLATE -APPS_SHORT_NAME HR -CUSTOM_MODE FORCE -XDO_FILE_TYPE XSL-FO -LANGUAGE en -LOB_CODE SHORTNAME -FILE_NAME FILENAME.xsl

DD:
 $FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct FILENAME.ldt


No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...