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

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD BLUE44BLACK \
-JDBC_CONNECTION cgebsu03d1.cg1.clckwrk.com:1521:CGEBSU03 \
-APPS_SHORT_NAME XXCL \
-DRVX_FILE XXCL010D2.drvx \
-DS_CODE XXCL010D2


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');

Download Command

FNDLOAD apps/$apps_password 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct demo.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXPO DATA_SOURCE_CODE=demo

DATA_SOURCE_CODE :- Template Code used during registration.

It will generate demo.ldt file containing the definition of the template.

Upload Command

FNDLOAD apps/$apps_password 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct data_source.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXPO DATA_SOURCE_CODE=demon – CUSTOM_MODE=FORCE

XDOLoader Utility – Download/Upload Templates

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.

Download Command

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

-DB_USERNAME <db_username> \

-DB_PASSWORD <db_password> \

-JDBC_CONNECTION <jdbc_con_string> \

-LOB_TYPE <lob_type> \

-APPS_SHORT_NAME <application_short_name> \

-LOB_CODE <lob_code> \

-LANGUAGE <language> \

-TERRITORY <territory> \

-LOG_FILE <log file>

 

Below is description of syntax – Command option (Mandatory/Option) – Description

• DOWNLOAD (M) – The first parameter: DOWNLOAD
• DB_USERNAME (M) – Database user name (example: apps).
• DB_PASSWORD (M)- Database user password (example: manager).
• JDBC_CONNECTION JDBC (M)- database connection string (example: ap000sun:1521:db222)
• LOB_TYPE (M) – XDO LOB type. Valid values are:
• TEMPLATE
• XML_SCHEMA
• XML_SAMPLE
• APPS_SHORT_NAME (M) – Application short name (example: AR).
• LOB_CODE (O) – XDO LOB code. Enter either the Template Code or the Data Definition Code (see below).
• LCT_FILE (O) -This is the control file for XML Publisher metadata (see below).
• LANGUAGE (M) – ISO two-letter language code (example: en) Mandatory for template files only

 

Upload Command

To Upload the files, first set up your environment for your session by setting the
APPL_TOP and CLASSPATH.

Execute the XDOLoader utility as follows:

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

-DB_USERNAME <db_username> \

-DB_PASSWORD <db_password> \

-JDBC_CONNECTION <jdbc_con_string> \

-LOB_TYPE <lob_type> \

-APPS_SHORT_NAME <application_short_name> \

-LOB_CODE <lob_code> \

-LANGUAGE <language> \

-TERRITORY <territory> \

-XDO_FILE_TYPE <xdo_file_type> \

-NLS_LANG <NLS_LANG> \

-FILE_CONTENT_TYPE <file_content_type> \

-FILE_NAME <file_name> \

-OWNER <owner> \

-CUSTOM_MODE [FORCE|NOFORCE] \

-LOG_FILE <log file>

Below is the description of syntax – Command option (Mandatory/Option) – Description

• UPLOAD (M) – The first parameter
• DB_USERNAME (M) – Database username (example: apps).
• DB_PASSWORD (M) – Database user password (example: manager).
• JDBC_CONNECTION (M) – JDBC database connection string
  (example: ap000sun:1521:db222)
• LOB_TYPE (M) – XDO LOB type.
  Valid values are:
  TEMPLATE
  XML_SCHEMA
  XML_SAMPLE
• APPS_SHORT_NAME (M) – Application short name (example: AR).
• LOB_CODE (M) –  XDO LOB code. Enter either the Template Code or the Data Definition Code.
• NLS_LANG (M) Enter the NLS_LANG environment variable.
• LANGUAGE (O) – ISO two-letter language code (example: en).
  If NLS_LANGUAGE=’TRADITIONAL CHINESE’, then
  cn_TW and if NLS_LANGUAGE=’SIMPLIFIED CHINESE’
  then cn_CN for combination of language and territory.
• TERRITORY (M) –  ISO two-letter territory code (example: US),
  default is ’00’.
• XDO_FILE_TYPE (M) – Enter the XDO file type, valid values are: PDF, RTF, XLS, XSL-FO, XSL-HTML, XSL-XML, XSLTEXT, XSD, XML, RTF-ETEXT
• FILE_CONTENT_TYPE (O)-  Content type of the file (example: text/html,application/pdf)
• FILE_NAME (M) -Name of the file you want to upload. (example: sample.pdf or test.xml)
  This file name can be full path (example: /u01/oracle/11iapp/xdo/115/patch/115/publisher/templates)
• OWNER (O) – Owner of the template. Default is “ORACLE”.
• CUSTOM_MODE (O) -Whether to force update. Valid values are
  FORCE and NOFORCE (default).
• LOG_FILE (O) – Enter a file name for the output log file (default: xdotmpl.log).
• DEBUG (O) -Turns debug on or off. Valid values are: true 7 false (default)
• USE_APPS_CONTEXT (O) – Whether to use AppsContext or not. Valid values
  are: true / false (default)
  If false, ’1’ is always used for Apps Login ID.