Saturday, December 17, 2011

How to Use XML Bursting to Send XML Report via Email

Oracle Bursting Mechanism enables us to deliver a single XML Publisher report/letter to multiple destinations simultaneously.One can create a single report/letter , then send it in any format (e.g., PDF or HTML) to multiple destinations(email ids).
There are two kind of bursting mechanism available within BI publisher
1) Control File Base:- Integrated with EBS
2) Delivery SQL based:- Part of Enterprise release.All delivery, template, output format, locale and other details define through delivery SQL Query. Enterprise Edition assume that this information is stored in data base. The process create the XML file out if this query and the delivery xml file works as control file.
 
Here we will discuss about the "Control File Base" mechanism.
 
To read the full document go to Shareapps4u