Oracle XML Publisher Template Builder - Insert Table/Form Dialog

Insert Table/Form Dialog

The Insert Table/Form dialog is the most flexible tool of the template builder. It allows you to perform the following tasks:

·         Create a simple or nested table with a variable number of rows.

·         Associate a group of data elements, such as a complete invoice or a purchase order line,  with a form in the document that will be repeated for each occurrence of the data element

·         Select and define a layout for all the data fields in the template

·         Group or re-group the data

Oracle BI publisher training with OA Frame work

You may have known different ways of generating the XML data while using the same RTF layout template. In this example, you will generate a BI Publisher report using OA Framework. In OA Framework, you do not need to use a data template or an Oracle Report to generate a BI Publisher report. Instead, the XML data is sourced from something known as view objects.

In this example, you will develop a very simple page with a button on it. When you click the Show BI Report button, the BI Publisher report will be displayed to the user on the screen. Behind the scenes, the following events will happen when the button is clicked:

XML Publisher using a Data Template and XDODTEXE

Check out the blog post for developing an  
XML publisher report using an RDF file

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.

Comparison between XML Publisher and Oracle Reports

In Oracle Reports, a single executable RDF file contains the data source, layout, business logic, and the language-specific prompts. However, BI Publisher separates these components into different layers. Following are some of the key limitations of Oracle Reports that are overcome by BI Publisher:

Mapping data to the template in XML publisher Reports

The mapping of data to the XML template is just similar to providing a source to the field in a report builder layout model.

XML Publisher Concurrent program - XMLP

In this blog post I will detail the step by step process of developing a XML publisher report using an RDF type report concurrent program in oracle apps.

The XML publisher windows desktop patch has to be applied in you PC before developing the XML template