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.

XML Publisher data template file structure

The XML Publisher(XMLP / BI Publisher) requires a Template layout and Data XML to generate the report in PDF, EXCEL, RTF or HTML format. The Data XML can be generated from Oracle Report and thru Data Template.