25 Dec 2014

XDOLoader command to migrate XML/BI publisher reports



XDOLoader command to migrate XML publisher reports



  • To load XML file to data definition:

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $apps_user -DB_PASSWORD $apps_pwd -JDBC_CONNECTION $host:$port:$sid  -LOB_TYPE TEMPLATE -APPS_SHORT_NAME PO -LOB_CODE "XXTEST BLANKET PO" -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE XSL-FO -NLS_LANG AMERICAN -FILE_CONTENT_TYPE 'text/xml' -FILE_NAME $NCUST_TOP/reports/US/UTF-8en-usXXTEST_Blanket.xsl -OWNER ORACLE -CUSTOM_MODE FORCE


  •  To load RTF file

 java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $apps_user -DB_PASSWORD $apps_pwd -JDBC_CONNECTION $host:$port:$sid  -LOB_TYPE TEMPLATE -APPS_SHORT_NAME NCUST -LOB_CODE XXTEST_REP -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF -NLS_LANG AMERICAN -FILE_CONTENT_TYPE 'application/rtf' -FILE_NAME $NCUST_TOP/reports/US/XXTEST_REP.rtf -OWNER ORACLE -CUSTOM_MODE FORCE