FNDLOAD to Download and Upload XML Publisher Data Template (.xml) Report

The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publisher database tables. Use this utility to download files from one instance and load to another.

To migrate an XML Publisher report first download download Concurrent Program & XML Publisher from source system.

1. Download LDT file for Concurrent Program
2. Download LDT file for XML Publisher Template and Data Definition

 Move the Generated LDT Files to Target System and execute below commands to upload. 

1. Upload LDT For Concurrent Program
2. Upload LDT For XML Publisher Template and Data Definition
3. Upload XML Publisher Data Deifinition XML File 
4. Upload XML Publisher RTF File  

Download LDT file for Concurrent Program:-
FNDLOAD apps/${P_APPS_PASSWORD} 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CP_NAME.ldt   PROGRAM APPLICATION_SHORT_NAME="XXAPP" CONCURRENT_PROGRAM_NAME="XX_CP_NAME"


Download LDT file for XML Publisher Data Definition and Template :-
FNDLOAD apps/${P_APPS_PASSWORD} 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_CP_NAME_XML.ldt      XDO_DS_DEFINITIONS DATA_SOURCE_CODE=XX_CP_NAME        APPLICATION_SHORT_NAME=XXAPP
 

Upload LDT For Concurrent Program:-
FNDLOAD apps/${P_APPS_PASSWORD} 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CP_NAME.ldt   UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Upload LDT For XML Publisher Template and Data Definition:-
FNDLOAD apps/${P_APPS_PASSWORD} 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_CP_NAME_XML.ldt


Upload XML Publisher Data Deifinition XML File:-
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD ${P_APPS_PASSWORD} \
-JDBC_CONNECTION ${P_READ_JDBC_CONN} \
-LOB_TYPE DATA_TEMPLATE \
-APPS_SHORT_NAME XXAPP\
-LOB_CODE XX_CP_NAME \
-LANGUAGE en \
-TERRITORY 00 \
-TRANSLATE Y \
-XDO_FILE_TYPE XML \
-NLS_LANG en \
-FILE_CONTENT_TYPE 'text/html' \
-FILE_NAME XX_CP_NAME.xml \
-LOG_NAME XX_CP_NAME.xml.log \
-CUSTOM_MODE FORCE

 Upload XML Publisher RTF File:-
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD ${P_APPS_PASSWORD} \
-JDBC_CONNECTION ${P_READ_JDBC_CONN} \
-LOB_TYPE TEMPLATE_SOURCE \
-APPS_SHORT_NAME XXAPP\
-LOB_CODE XX_CP_NAME \
-LANGUAGE en \
-TERRITORY 00 \
-TRANSLATE Y \
-XDO_FILE_TYPE RTF \
-NLS_LANG en \
-FILE_CONTENT_TYPE 'application/rtf' \
-FILE_NAME XX_CP_NAME.rtf \
-LOG_NAME XX_CP_NAME.rtf.log \
-CUSTOM_MODE FORCE
 
 Here provide P_APPS_PASSWORD as Data base apps password.

P_READ_JDBC_CONN (JDBC database connection string)-->Ex:  ap000sun:1521:apps115

Verify below tables after executing FNDLOAD Command:-
For Data Definition:-

  SELECT *
  FROM XDO_DS_DEFINITIONS_B
WHERE DATA_SOURCE_CODE = 'XX_CP_NAME';

SELECT *
  FROM XDO_DS_DEFINITIONS_TL
WHERE DATA_SOURCE_CODE = 'XX_CP_NAME';

SELECT *
  FROM XDO_LOBS
WHERE  LOB_CODE = 'XX_CP_NAME'
            AND APPLICATION_SHORT_NAME = 'XXAPP'
            AND LOB_TYPE IN
                   ('XML_SCHEMA',
                    'DATA_TEMPLATE',
                    'XML_SAMPLE',
                    'BURSTING_FILE');

For Data Template:-
SELECT *
  FROM XDO_TEMPLATES_B
WHERE TEMPLATE_CODE = 'XX_CP_NAME';

SELECT *
  FROM XDO_TEMPLATES_TL
WHERE TEMPLATE_CODE = 'XX_CP_NAME';

SELECT *
  FROM XDO_LOBS
WHERE LOB_CODE = 'XX_CP_NAME'
           AND APPLICATION_SHORT_NAME = 'XXAPP'
            AND LOB_TYPE IN ('TEMPLATE_SOURCE', 'TEMPLATE');