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
4 comments:
Great, great, great article; the first one I found after days of searching that addressed what I need to do AND in the right environment. But here is one more question - I have a concurrent program (an execution report) report where the user can choose - via a parameter - to run either a Detail or a Summary version of the report. The report uses a plsql package; the BeforeReport function builds the queries and the AfterReport function calls the XDOBURSTREP program. The process uses an xml data definition to create the datasets based on the queries built in BeforeReport. And it uses .rtf template to create a pdf document. And using an xml bursting control file
So, how would I CONDITIONALLY call one template or the other in the example you used above - based on the users parameter choice? I will create one template - but only want to define one data defintion.
Much thanks,
Sharon
Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
¬Oracle Fusion HCM Online Training
I tried the approach and received 4 separate email with one attachment each. Please let me know what should I be looking for.
Hi...thank you for the details. I tried the approach, its sending 4 emails with one attachment instead 1 with 4 attachments. Please let me know is it intended to to send or 4 mails? thank you.
Post a Comment