Oracle Application's Blog: XML Bursting in Oracle Apps

XML Bursting in Oracle Apps: How to sent multiple Report output templates in a Single Bursting Control file.

Hi Friends, In this post we will discuss how we can sent the output of the report in multiple XML templates in a single control file through XML Bursting.

We know that we can create attach multiple templates in a single Concurrent Program and then choose the different template during Concurrent program submission. But usually in the bursting control file we can mentions only single template. But we can mention different templates in a single Bursting control file through this method.

First we need to fetch , which template users is selecting during the concurrent program submission.

We can get the name of the template through this sql query.

select ARGUMENT2 into v_template_name from fnd_conc_pp_actions

where CONCURRENT_REQUEST_ID=:P_CONC_REQUEST_ID

With this Sql we will get the name of the template user selected during program submission.

We will use these below query as a CF column in the report to fetch the template locations.

select ARGUMENT2 into v_template_name from fnd_conc_pp_actions

where CONCURRENT_REQUEST_ID=:P_CONC_REQUEST_ID

select xtb.application_short_name||'.'||xtb.template_code ||'.'||

xtb.default_language ||'.'||

xtb.default_territory

from apps.xdo_templates_b xtb

where xtb.template_code =v_template_name

I have created CF column CF_TEMPALTE in the report to get the Template name and its location. Then I will use this CF Column in the XML Bursting Control file in the place of Template Location as Highlighted below. This will make your template dynamic not fixed.

XML Bursting in Oracle Apps: How to sent multiple Report output templates in a Single Bursting Control file.

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.