XDO Tables & FNDLOAD scripts

XDO_DS_DEFINITIONS_B
XDO_DS_DEFINITIONS_TL

XDO_TEMPLATES_B
XDO_TEMPLATES_TL
XDO_LOBS


XDO_FONT_MAPPINGS
XDO_FONT_MAPPING_SETS_B
XDO_FONT_MAPPING_SETS_TL

select * from XDO_DS_DEFINITIONS_B where data_source_code = 'Data source short code'
select * from XDO_DS_DEFINITIONS_TL where rownum < 3

select * from XDO_TEMPLATES_B where TEMPLATE_CODE = 'Template Short code'
select * from XDO_TEMPLATES_TL where TEMPLATE_CODE = 'Template Short code'
select * from XDO_LOBS where lob_code = 'Template Short code'

how to move xml publisher reports from one instance to another instance using fndload.

The FNDLOAD utility is used to upload and download the data definition and Data template created via XML Publisher Administrator responsibility.
The XDOLoader utility is used to upload and download the physical files (RTF, PDF, XSL-FO, XML, and XSD).

Use the following commands to
1) Download all the data definitions and corresponding templates in an instance.
FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
targetldtfile.ldt XDO_DS_DEFINITIONS

2) Download all the data definitions and the corresponding Templates in a specific product.
FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXX

3) Download a particular data definitions and its corresponding Templates.
FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXX DATA_SOURCE_CODE=EMP DD

4) Upload the data definitions and its corresponding Templates to an instance.
FNDLOAD apps/apps_pwd@db 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
targetldtfile.ldt

XDOLOADER :
To download the RTF template and other files use
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD
-DB_USERNAME
-DB_PASSWORD
-JDBC_CONNECTION
-LOB_TYPE
-APPS_SHORT_NAME
-LOB_CODE
-LANGUAGE
-TERRITORY
-LOG_FILE

Use the below command to upload the rft template and other files
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD
-DB_USERNAME
-DB_PASSWORD
-JDBC_CONNECTION
-LOB_TYPE
-APPS_SHORT_NAME
-LOB_CODE
-LANGUAGE
-TERRITORY
-XDO_FILE_TYPE
-NLS_LANG
-FILE_CONTENT_TYPE
-FILE_NAME
-OWNER
-CUSTOM_MODE [FORCENOFORCE]
-LOG_FILE

Calling Subtemplate from main Template

Applies to:
BI Publisher (formerly XML Publisher) - Version: 5.6.2 to 5.6.3 [Release: 5 to 5]
Information in this document applies to any platform.
13-Jun-2010
Goal
Link a RTF subtemplate to the original template in XML/BI Publisher because only the original template is visible for viewing in the PDF output.
This feature is provided in the BI Publisher (formerly XML Publisher) but there are no precise information in the user guide itself regarding this topic.



Solution
These are the steps to enable subtemplates:

1. In the subtemplate file, add the following tag to the beginning of the section to be included:

<?template:TemplateIdentifier?>
where (TemplateIdentifier) is whatever you would like to call this section of the subtemplate.

Note that in a single subtemplate file, you can have multiple entries, marking different segments you would like to include in other files.

2. Register the subtemplate in Template Manager by selecting Subtemplate=Yes

3. In the main template, include the following tag in the beginning of the file:

<?import:xdo: (product_short_name).(subtemplate_code).(lang).(terr)="" ?="">

The first 2 fields are whatever you registered your subtemplate as.
The last two are the locale for your subtemplate file.

For example:
<?import:xdo: ?="" xdo.test.en.us="">

4. In the place in your main template file where you would like to use the sub template,
add the following tag:

<?call:TemplateIdentifier?>

References
BUG:4483295 - HOW TO INCLUDE SUBTEMPLATE WITH IN THE REPORT USING XML PUBLISHER
NOTE:362496.1 - How to Determine the Version of Oracle XML Publisher for Oracle E-Business Suite 11i and Release 12