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.

XML Publisher training with example

You will follow these steps to complete the process:

1. Prepare XML data Create an XML file with a customer and its invoice listing using Notepad or an equivalent tool.

2. Load the XML file Load the XML data file. The file can be uploaded using the Oracle BI Publisher menu path Data | Load XML Data.

3. Develop the template Use the BI Publisher syntax to loop through the records and reference data from the XML file. You will also display running totals.

4. Save the file Save the file with an .rtf extension.

5. View the output Use the preview feature of BI Publisher plug-in to view the final output that BI Publisher report will produce.