XML Bursting in Oracle Apps

XML Bursting in Oracle Apps

 

Hi Friends, In this post we will discuss how we can create XML bursting control file to send xml reports output in email. Through XML Bursting we can send XML reports outputs to email id's. We need to create a Bursting control file for this and attach this bursting file to the that report data definition for that you want to send its report output through bursting.and in this bursting control file we put all the logics to send and create emails and the templates which will be sent as a bursting file output.

 

 

Report Output in XML Format on Which We will create XML Bursting File:-

To create bursting file , first you need to save the output of the report in xml format as below and then crate bursting control file as per the requirement according to the groups of the report in the xml format as highlighted below.

 

Bursting Control File:-

This is the control file you need to create and save as .xml

 

 

 To get the location of the Template then you can use this below Query:

select xtb.application_short_name||'.'||
xtb.template_code ||'.'||
xtb.default_language ||'.'||
xtb.default_territory
from apps.xdo_templates_b xtb
where xtb.template_code ='XX_TEST_TEMPLATE_CODE'.


Attach XML Bursting Control file to Report Data Definition for which you want to send the report output to customers.
Go to XML Publisher Administration Responsibility ==> Data Definition.

 

 

 

 

How to put email addresses and others Data in Bursting Control File Dynamic.

Support you want to do bursting for AR invoice and want to send the AR invoice directly to Customer as per their email addresses in the Customer Master. So for that you first need to create CF column or need to create column in the report and fetch the customer email in that CF column. then use this Column of the report in Bursting Control File like below. I have fetch Customer Email in to the column CF_CUSTOMER_EMAIL in the report.

 

 

 

XML Bursting in Oracle Apps