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

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.