XML Publisher using a Data Template and XDODTEXE

Create a concurrent program: Use the output format as XML

Define a Data Definition for the concurrent program:

Concurrent program short name and Data definition code has to be same. 

Create the data template file and upload it while defining in the data definition

Attach the concurrent program to a responsibility:

Run the concurrent program:

Save the output as .XML file:

Use the .XML file to design the template definition: Save the file as .rtf file

Create the template definition with the .rtf file:

Change the concurrent program output format to PDF:

Run the concurrent program:

XML Publisher Concurrent program - XMLP

In this blog post I will detail the step by step process of developing a XML publisherreport 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

Overview

•          XML Publisher is a template based publishing solution by Oracle which allows us to create visually rich documents with numerous formatting options. (Available in ver.11.5.10)

•          XML Publisher makes use of the data retrieved from Reports 6i.

•          The template, designed by the developer is used as the layout for the report.

•          The template will contain the layout with tags that are mapped to the data model of the report.

•          At runtime the data from reports is merged onto the designed template to produce the final report.

Here it goes:

Before we see the step by step process, I will brief the main points:

       ·   Create a report and register it as Concurrent Program of type XML

       ·   Build a Data Definition & XML Template using XML Publisher

       ·   Create a relation between the XML Template & Concurrent Program

Develop a RDF Report concurrent program in oracle apps:

1.      Develop a RDF report and register it in oracle apps

·         Develop the Report (Report Name: Sample XML Report) Data model

·         Develop the Report Layout model

·         Define the RDF executable

·         Define the concurrent program

·         Assign this concurrent program to a responsibility

The RDF report concurrent program is complete, now we have to get the XML data file from the concurrent program and create the .xml file:

2.      Run the report from a responsibility after changing the output format of the concurrent program to XML.

·         Go to the concurrent program definition and change the output format of the concurrent program

·         Run the concurrent program

·         The XML data output of the concurrent program will look like this pic below

If you map the oracle report data model and the xml data file. It will look like this

·