XML bursting with multiple attachments
Here we will be discuss about the XML bursting feature in oracle apps. How we can send the Multiple attachments in one email through the XML bursting program. First of All we need to Understand about the XML Bursting and if you are new to this Technology then I will recommend you to Just go through my XML Bursting Tutorial. Basically XML bursting is uses to send the outputs of the Concurrent program through Email but some times we need to send the output of the programs in multiple Layouts with different information's and we want to sent these different layouts in different attachments with XML bursting. Here I will share the steps for how to send multiple attachments with XML bursting.
Steps to Implement multiple attachments in XML bursting
Step1:- We need to put some logic in the XML bursting CTL file to send output in Multiple Attachments.
Step2:- Go to the XML publisher responsibility ==> Data Definition
Query the Data Definition for which you have already implemented the XML bursting.
Download the Bursting Control File (XML Bursting File)
Step3:- In the Bursting Control File , we need to do changes like Below to send multiple attachments
As Highlighted Below , I have used the 4 <xapi:document> tags in the Bursting Control File and Each <xapi:document> tag I have user <xapi:template> tag. These tags in the CTL file to put the XML output of the Concurrent Program in the XML rtf Templates. here I have used the 4 different template. It mean This bursting Control file send 4 attachments in the Email notifications to the recipient.
These 4 Templates should be attached to the Concurrent Program through XML administrator.
We can get the Template path 'XXAP.XX_CREDITOR_LEDGER_V1.en.00" from this below sql 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 =v_template_name
