Friday, 26 May 2017

XML Publisher FND LOAD

Step 1: Concurrent Program download and upload


FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct /export/home/appldev/XX_GL_TRI_BAL.ldt PROGRAM APPLICATION_SHORT_NAME=XXNPS CONCURRENT_PROGRAM_NAME=XX_GL_TRI_BAL

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct /export/home/appldev/XX_GL_TRI_BAL.ldt

Step 2: XML Publisher data definition and template download and upload

FNDLOAD apps/apps O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_GL_TRI_BAL_TEMP_DATA.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXNPS DATA_SOURCE_CODE=XX_GL_TRI_BAL TMPL_APP_SHORT_NAME=XXNPS TEMPLATE_CODE=XX_GL_TRI_BAL

FNDLOAD apps/apps O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct /export/home/appldev/XX_GL_TRI_BAL_TEMP_DATA.ldt

Step3: RTF(OR)Template file upload and download

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION erp-test:1528:UAT \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME XXNPS \
-LOB_CODE XX_GL_TRI_BAL \
-LANGUAGE en \
-TERRITORY US \
-LOG_FILE xdotmpl.log \
-DEBUG true

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION erp-dev.:1541:TEST \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME XXNPS \
-LOB_CODE XX_GL_TRI_BAL \
-LANGUAGE en \
-XDO_FILE_TYPE RTF \
-FILE_CONTENT_TYPE text/html  \
-FILE_NAME /export/home/appldev/XX_GL_TRI_BAL.rtf \
-CUSTOM_MODE FORCE