Category Archives: XML/BI

XML Bursting from RDF

XML Bursting from RDF

Log on to Oracle EBS using user having System Administrator responsibility to register the Oracle Report.

Creating Executable:

XMLBursting012

Create concurrent program for the executable:

XMLBursting013

Add the parameters for the Program:

XMLBursting014

Add the Concurrent Program to OM Concurrent Programs Request Set:

XMLBursting015

Go to Order Management Responsibility and run the request:

XMLBursting016

Change the output of the concurrent program to create the xml template file .rtf layout in ms word. Create data definition with Code same as the Concurrent Program Short Name:

XMLBursting017

Create Template for the Data definition and attached Template:

XMLBursting018

Run the Concurrent Program and Go to report builder open your existing report, go to report triggers open after report add the below code for bursting code:

Compile the code the save the report.

Design XML Bursting control file, Below are the format of bursting control file:

Goto XML Publisher Responsibility —> data definition —>  Search for the data definition with data definition code or data definition and Attach your bursting control file at Bursting Control File Option.

XMLBursting019

XMLBursting020

XMLBursting021

Once done Run the program to get email with an attachment of the XML Template with splitting based on the Sales Order.

AllOracleAppsXMLBursting

Thanks to Madhav Kumar for Providing the Files on XML Bursting.

Related posts:

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: