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

7 comments:

  1. Usually I do not read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Thanks, very nice article.
    Home Interior Decorators in Chennai
    Home Interior Designers in Chennai
    Home Interiors in Chennai

    ReplyDelete
  2. It's interesting that many of the bloggers to helped clarify a few things for me as well as giving.Most of ideas can be nice content.The people to give them a good shake to get your point and across the command
    interior designers in chennai
    best interior designers in chennai

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete