Search Results


Tuesday, November 29, 2016

How to deploy XML publisher report to R12

XML Publisher deployment



To deploy concurrent program and request groups follow this link (FNDLOAD).

Deploy XMLP Entries

Following creates metadata for the XML publisher data definition and the associated template. This entries have to be created before uploading the actual files.

FNDLOAD apps/apps O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XXC_CUSTOM_S.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXC' DATA_SOURCE_CODE='XXC_CUSTOM' TMPL_APP_SHORT_NAME='XXC' TEMPLATE_CODE='XXC_CUSTOM'



FNDLOAD apps/apps O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct CUSTOM.ldt


Deploy RTF


java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD -DB_USERNAME $APPS_UN \
-DB_PASSWORD $APPS_PW -JDBC_CONNECTION \
$DB_IP_ADDR:$DB_PORT_NO:$APPS_INS \
-LOB_TYPE TEMPLATE -LOB_CODE XXCUSTOM_CODE \
-APPS_SHORT_NAME $XXC -LANGUAGE 'en' \
-XDO_FILE_TYPE 'RTF' -FILE_CONTENT_TYPE 'application/rtf' \
-lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct \
-LOG_FILE LXXCUSTOM.log \
-FILE_NAME $LOAD_DIR/XXCUSTOM.rtf \
-CUSTOM_MODE FORCE


Deploy XLS



java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME $APPS_UN \
-DB_PASSWORD $APPS_PW \
-JDBC_CONNECTION $DB_IP_ADDR:$DB_PORT_NO:$APPS_INS \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME $XXC \
-LOB_CODE XXCUSTOM_CODE \
-LANGUAGE en \
-TERRITORY 00 \
-NLS_LANG American_America.AL32UTF8 \
-XDO_FILE_TYPE XLS \
-FILE_CONTENT_TYPE application/rtf \
-FILE_NAME XXCUSTOM.xls \
-LOG_FILE L_XXCUSTOME.log     -CUSTOM_MODE FORCE


Deploy Data template



java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME $APPS_UN \
-DB_PASSWORD $APPS_PW \
-JDBC_CONNECTION $DB_IP_ADDR:$DB_PORT_NO:$APPS_INS \
-LOB_TYPE DATA_TEMPLATE \
-APPS_SHORT_NAME $XXC \
-LOB_CODE XXCUSTOMER_CODE \
-LANGUAGE en \
-TERRITORY 00 \
-NLS_LANG American_America.AL32UTF8 \
-XDO_FILE_TYPE XML-DATA-TEMPLATE \
-FILE_CONTENT_TYPE text/xml \
-FILE_NAME XXCUSTOM.xml \
  -LOG_FILE L_XXCUSTOM.log       -CUSTOM_MODE FORCE



Post a Comment