XML Data Definition, Data Template & RTF Template Migration

For the migration of an XML Publisher report that is based on a data template, you can follow the below XDOLOADER commands.

For download and upload the files you will need the below information. I have used some dummy values which you can replace as per your requirements.

Apps Password	Test123
Database	TESTDEV
Host Name	testdev.net
Port	1234
Data Definition Name	Test Data Definition
Data Definition Code	TEST_DATA_DEF
Data Template	TEST_DATA_DEF.XML
Application	XXTEST
Template Name	Test Data Template
Template Code	TEST_DATE_TEMPLATE
Template Type	RTF
RTF File	TEST_DATA.RTF
Language	English
Territory	United States
Output Type	Excel
Log File Path	$CUST_TOP/log

1] First download the Data Definition as below:

$FND_TOP/bin/FNDLOAD apps/Test123@TESTDEV 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct TEST_DATA_DEF_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXTEST' DATA_SOURCE_CODE=' TEST_DATA_DEF’

2] Download Data Template (XML File):

 

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \

-DB_USERNAME apps \

-DB_PASSWORD Test123 \

-JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= testdev.net)(PORT=1234))(CONNECT_DATA=(SERVICE_NAME= TESTDEV)))'

-LOB_TYPE DATA_TEMPLATE \

-LOB_CODE TEST_DATA_DEF \

-APPS_SHORT_NAME XXTEST \

-LANGUAGE en \

-lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct \

-LOG_FILE $CUST_TOP/log

 

3] Upload the Data Definition:

 

 

$FND_TOP/bin/FNDLOAD apps/Test123@TESTDEV 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct TEST_DATA_DEF_DD.ldt

 

4] Upload Data Template (XML File):

 

 

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \

-DB_USERNAME apps \

-DB_PASSWORD Test123 \

-JDBC_CONNECTION testdev.net:1234: TESTDEV \

-LOB_TYPE DATA_TEMPLATE \

-LOB_CODE "TEST_DATA_DEF" \

-XDO_FILE_TYPE XML \

-FILE_NAME "$CUST_TOP/install/TEST_DATA_DEF.XML" \

-APPS_SHORT_NAME "XXTEST" \

-NLS_LANG en \

-TERRITORY US \

-CUSTOM_MODE FORCE \

-LOG_FILE $CUST_TOP/log

 

5] Upload the RTF Template. First place the .RTF file in some location (e.g. $CUST_TOP/install/TEST_DATA.rtf)

 

 

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \

-DB_USERNAME apps \

-DB_PASSWORD Test123 \

-JDBC_CONNECTION testdev.net:1234: TESTDEV \

-LOB_TYPE TEMPLATE \

-APPS_SHORT_NAME “XXTEST " \

-LOB_CODE "TEST_DATE_TEMPLATE" \

-LANGUAGE en \

-XDO_FILE_TYPE RTF-ETEXT \

-FILE_CONTENT_TYPE 'text/html' \

-FILE_NAME "$CUST_TOP/install/TEST_DATA.rtf" \

-CUSTOM_MODE FORCE