XML bursting control file

XML bursting control file

We all know that XML bursting in Oracle apps r12. To send the Repot outputs in the Emails and to split the one Concurrent Request output in multiple Outputs to send email we uses XML bursting for this but the important part in the XML bursting is the bursting control file in which we design all the Logic of Splitting of Report output and many other Important Email Objects like from , To and CC email addresses. Email servers Information's also we puts in the XML bursting control file. Here below I will explain all about XML bursting control file.

 

Functioning of XML bursting control file

This is the one Sample of the XML bursting control file .

 

 

Important Objects of XML bursting control file

 1.<xapi:request> This tag decide in the bursting control file that concurrent request output will split based on which group.

For Example I have one RDF of Customer Invoice which have to reports Group (XX_CUSTOMER and then XX_CUST_INVOICE).

 

Now I only want to send only one Email for Each Customer then I will use

 

<xapi:request select="/XX_REPORT_NAME/XX_CUSTOMER">

 

But if I want to send  Email for Each Invoice  then I will use

 

<xapi:request select="/XX_REPORT_NAME/XX_CUSTOMER/XX_CUST_INVOICE">

 

You can also this

"/XX_REPORT_GROUP1/XX_REPORT_GROUP2/XX_REPORT_GROUP3" grouping idea from your Concurrent Program XML output. GO to Concurrent Request of the Concurrent Program and View the Output in XML. You can get the idea from there about all reports xml groups names and you can use these names in the Bursting Control File <xapi:request> tag.

 

2.<xapi:email> This Tag is uses for the SMTP server configuration which will be used by bursting program to sent emails. Here we store SMTP server name , SMTP port, From Email address and reply_to address etc.

 

3..<xapi:message> This tags decide email will go to which recipients (to and cc email addresses) and we can also design the Email body of the XML bursting email Notifications.

 

4.<xapi:template> This tags decide the RTF template in which XML output will loaded from Concurrent request to send as a attachment in the Busting Email notifications.

 

XML bursting control file