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