Migration of XML Publisher Objects using LDTs and XMLLoader

An XML Publisher template defintion will have following things to migrate.

1) Template defintion & Data defintion  => Use FNDLOAD
2)  Actual layout templates (RTF/EXCEL/PDF) & Actual data defintion XML file. => use XDOLOADER command


Template defintion & Data defintion 
FNDLOAD apps/<appsPwd> 0 Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XXCUSTEMPL.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='Data defintion Code' TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='Template Code'

With the above command you will fetch both data defintion and template defintion.

You upload the above using the UPLOAD command.

FNDLOAD apps/<appsPwd> 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXCUSTEMPL.ldt

Once the definitions are created in the instance, you need to upload the actual layout and data defintion files using XDOLOADER.

Data Template/Data Source:

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD <appsPwd> -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_DB_HOST_NAME)(PORT=XX_DB_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_DB_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_DATA_TEMPL_CODE -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME


java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD <appsPwd> -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_DATA_TEMPL_CODE -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME


 RTF TEMPLATE (Report Layout .rtf file) 

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appsPwd  -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME




java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appsPwd -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NAME.rtf -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME