Introduction to XML

The evolution of XML is due to the requirement for a platform independent tool for carrying information within and across the networks. XML’s temporal relationship to SGML (Standard Generalized Markup Language) and HTML (Hyper Text Markup Language) is depicted in the figure below.

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.

Oracle Apps developer responsibilities - Download

A normal routine for an oracle apps developer is to understand the customer requirements, develop the code, perform testing and move the tested codes to different application/ database instances. There are some technical aspects involved in this process that every developer should know. Here is a document which covers all such topics in details.

xml publisher data template xml