XML Publisher - Templates/Sample/Control Migration

Short post about command line syntax to migrate XML Publisher Template, Data Sample and Burst Control.


1. Template Migration

 java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=server.db.com)(PORT=9999)) (CONNECT_DATA=(SID=SID))) " \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME PO \
-LOB_CODE XML_PUB_TEMPLATE_CODE \
-LANGUAGE en \
-TERRITORY CA \
-XDO_FILE_TYPE RTF \
-NLS_LANG UTF8 \
-FILE_NAME XML_PUB_OUTPUT_TEMPLATE.rtf \
-CUSTOM_MODE FORCE

2. Data Sample Migration

 java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=server.db.com)(PORT=9999)) (CONNECT_DATA=(SID=SID))) " \
-LOB_TYPE XML_SAMPLE \
-APPS_SHORT_NAME PO \
-LOB_CODE XML_PUB_TEMPLATE_CODE \
-LANGUAGE en \
-TERRITORY CA \
-XDO_FILE_TYPE XSL-XML \
-NLS_LANG UTF8 \
-FILE_NAME PO_XML_SAMPLE_DATA.xml \
-CUSTOM_MODE FORCE

3. Burst Control Migration

 java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=server.db.com)(PORT=9999)) (CONNECT_DATA=(SID=SID))) " \
-LOB_TYPE BURSTING_FILE \
-APPS_SHORT_NAME PO \
-LOB_CODE XML_PUB_TEMPLATE_CODE \
-LANGUAGE en \
-TERRITORY CA \
-XDO_FILE_TYPE XML-BURSTING-FILE \
-NLS_LANG UTF8 \
-FILE_NAME XML_PUB_BURST_CTRL.xml \
-CUSTOM_MODE FORCE