XML Bursting from RDF

XML Publisher Bursting from RDF

Create a new Oracle Report using Oracle Report Builder using the following query:

Create new RDF as below:

Open Report Builder, Click on SQL Query in data model and enter your sql valid query.

XMLBursting001

 

Connect to database:

XMLBursting002

In the query passing two bind parameters (ORG_ID & SALES_ORDER_NUMBER) Click on ok button and the Variables are created in User Parameters Section.

XMLBursting003

XMLBursting004

XMLBursting005

Add one more mandatory parameter P_CONC_REQUEST_ID to have Trace generated after the Concurrent Program.

XMLBursting006

Save your report.

XMLBursting007

XMLBursting008

Compile the Report using Ctrl+Shift+K :

XMLBursting009

Move your report to custom top:

XMLBursting010

 

XML Bursting2

Related posts:

Leave a Reply