How to create a simple report using BI Publisher in Oracle E Business Suite R12

By Jag - May 06, 2014

There are several ways to implement a BI Publisher report in Oracle E Business Suite R12, but I’ll explain a simple way where your data is being retrieved in the XML data template file.
The XML data template file consists of 3 parts:

Parameters
DataQuery
DataStructure

First of all you need a SQL which retrieves the necessary data for your report.
As mentioned earlier the SQL is part of your XML Data Template file.
You’ll probably have to use parameters in your SQL.
Your SQL might be something like this (I have deleted big parts from the ‘from’ and ‘where’ clause, because this is a report used at one of our clients)

It is important that you use the exact same parameter names in your SQL, “” and Oracle E Business Suite Concurrent Program and yes: case sensitive.

The data structure has to be defined in your XML file as well.
In this case the data exists of 3 groups: book, property and assets

So in the end your XML Data Template file might look like this:

After you have created your XML Data Template file you need to upload it into Oracle E Business Suite.

You can do this via the following path:

First you need to create a new data definition

Choose a name, the application where the report needs to be added to, the code (concurrent program) and upload the XML Data Template file.

After you have created the data definition, than you have to add the RTF template to Oracle E Business Suite
You can do so through the following path:

The short name used in the concurrent program needs to be the same as the code used in the data definition of the XML Publisher data definition.

Set the output format on XML, because your BI Publisher (RTF) template uses XML as source to fill the document.
Click on parameters to set up your parameters.