8. Migration of XMLPub Templates :XDOLOADER Utility using FNDLOAD and XDO Loader:

The FNDLOAD utility is used to upload and download the data definition and Data template created via XML Publisher Administrator responsibility.

Example:
@devsystem unix server
FNDLOAD apps/apps@ODEV1 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XMLPData.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME= 

DATA_SOURCE_CODE=

For example :to download all data definitions and templates for Accounts Receivable, use the following command:
FNDLOAD apps/apps@ODEV1 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XMLPData.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=AR DATA_SOURCE_CODE=XXAROPNITM

Step 2 @test system unix server
FNDLOAD apps/appstst@OTST 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XMLPData.ldt

FNDLOAD usage:

a)To move all the data definitions and templates metadata from a particular instance

b)You can move all XDO metadata for a particular application such as custom (eg..XXX..) application or other like AP or AR.

XDOLoader is Java-based command line program utility to load template files for XML Publisher.
XDOLoader utility used to upload and download the physical files (RTF, PDF, XSL-FO, XML, and XSD).

The XDO Loader comes in two mode .
1)File download only mode: allows you to download files of the specified type (BURSTING_FILE, DATA_TEMPLATE,TEMPLATE,XML_SAMPLE,XML_SCHEMA) from a specified

application short name. This mode is normally used to download files from the XDO_LOBS table. Specify the target LOB_CODE, APPS_SHORT_NAME, and LOB_TYPE, LANGUAGE, and

TERRITORY to download all files that match the criteria.

2)File download and LDT/DRVX generation mode:allows you to download all the files (BURSTING_FILE,DATA_TEMPLATE,TEMPLATE,XML_SAMPLE,XML_SCHEMA) for a specified

application short name.
This mode can be used to download files from the XDO_LOBS tables and create and LDT file for the downloaded file. Note: A DRVX file is also created. This file is used

by Oracle Development to load templates during patch application. It is not required for use at your site and can be ignored.

Execute the XDOLoader utility as follows first for Download

% java oracle.app.do.ox.until.XDOLoader DOWNLOAD \
-DB_USERNAME \
-DB_PASSWORD \
-JDBC_CONNECTION \
-LOB_TYPE \
-APPS_SHORT_NAME \
-LOB_CODE \
-LANGUAGE \
-TERRITORY \
-LOG_FILE

Execute the XDOLoader utility as follows first for Upload

% java oracle.app.do.ox.until.XDOLoader UPLOAD \
-DB_USERNAME \
-DB_PASSWORD \
-JDBC_CONNECTION \
-LOB_TYPE \
-APPS_SHORT_NAME \
-LOB_CODE \
-LANGUAGE \
-TERRITORY \
-LOG_FILE