Oracle XML Publisher Moving Templates and Data Definitions between EBS Instances

XML Publisher stores all the meta data and physical files for templates and data definition in BLOB columns in its schema. It is therefore time consuming to manually download information from a development instance to a test and then to a production environment especially if there are many templates to manage.

XML Publisher uses the FNDLOAD loader technology and its own XDOLoader to allow you to move the metadata and physical files for your templates and datasources from one instance to another.

How to create a multilingual report in Oracle XML Publisher

There are two options for adding translated templates to your report definition:

•       Create a separate RTF template that is translated (a localized template)
This option is useful if the translated template requires a different layout for each language.

•       Generate an XLIFF file from the original template (at runtime the original template is applied for the layout and the XLIFF file is applied for the translation)

If the layout of the report is same for all languages and if we only require translation of the text strings of the template layout, use the XLIFF option.