XML Publisher

Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E- Business Suite. XML Publisher is a tool which enables the users to produce


Flexible

High Quality

Template-Based Reports

The main feature of XML Publisher is that it separates the Data Source from the presentation/Layout

Steps To Create:
 
1. CREATING AN ORDINARY XML REPORT
Create a Report using a Query in .rdf format.


STEP1: Open the Report Builder and Select the option to build the report manually.

The Query used is to bring the items created after 01-Jan-2008



SELECT inventory_item_id, segment1, description, creation_date

FROM mtl_system_items_b

WHERE creation_date > TO_DATE ('01-JAN-2008') AND organization_id = 204



Connect as apps/apps@prod

Create the Layout. [Actually, there is no need to create layout for XML report. Here, we have created it for demo purpose.]

The Output will be like this.

Save this Report in the Inventory Top.

oracle\prodappl\inv\11.5.0\reports\US\xinv.RDF

STEP2: Generate XML File

Save it.

This is the XML coding for the RDF File.

STEP 3: CREATE XML TEMPLATE


Now, we have to create a template for Output. For this open Microsoft word.



If XML was installed in Your system, You can see this

Now Load the XML data

Select the XML saved Data

Create the Template.

Here, we are inserting all those fields. So, Select All Fields.

You will get the layout as Follows

This is the Template, we have created. Save this as rtf file [Rich Text Format].

STEP4: REGISTER THE REPORT IN APPS




Open the Application.

Goto System Administrator Responsibility. Create the Executable

Save it. Create the Concurrent Program

Save it.
Add it to request group and submit the request
Out put wil be in XML form that it is not that we need.

STEP5 : ATTACHING THE TEMPLATE


Now GO to XML Publisher Administrator responsibility

Creating the Data Denition

When you create the data definition, you register the source of the data that will be merged with your template layout to create your published report.



We have to create the Data Definition Now.

By Default, it will be in the query mode. So Click CREATE DDF

One Important thing here is, Give the Code name same as the Conc Prgm Short Name in caps. Else it will not give the result.

If you are using the Oracle Applications concurrent manager to generate your report, the data definition Code must match the concurrent program short name of the report program (for example, RAXCUS for the Customer Listing Summary). This enables the concurrent manager to locate the templates available for the report concurrent program when you submit the request.

After the data definition is created, all the fields are updateable except Application and Code





Creating the Template

When you create a template, you assign it a data definition and upload your template layout files. Assigning the data definition makes the template available to the corresponding data source at runtime.



Now Attach the Template,

After the template definition is created, the following fields are not updateable: Application, Code, and Type




Now, you Run the Report in the Inventory Responsibility

If You see the output, it will come in the Format we have give. Here we have given as PDF