How to send xml publisher report by email to users

How to send XML publisher report by email to users

In this post, we will be discussing about, how to send the XML publisher report by email to users. As per business requirements, we do need to automatically email the xml Reports output to users. For example, we have Custom AR Invoice Report and we want, when we will run this report, this report output will automatically email to customer or users. Oracle has provided the feature in oracle apps to send the XML publisher report by email to users. This feature is called email Bursting. Email bursting only applicable for XML publisher reports. We will try to Implement the email bursting for XML publisher reports from scratch and will also discuss about the Bursting Control file and how we can design this. Here below are the complete steps about how to send XML publisher report by email to users

Step by Step to send xml publisher report by email to users

1. First Important thing to Implement the XML bursting is this , The Concurrent Program on which we are implementing or running the XML bursting should XML Based. It means its output type should be 'XML'

 

 

Step2:- Now to Copy the Short name of the Concurrent Program and Go to the XML Administrator Responsibility and Paste the Copied Short Name in the code

 

XML Administrator Responsibility ==> Date Definitions

 

Now Here we need to Attached the XML Bursting Control File which will have all the logic to burst the Concurrent program output in multiple emails

Step3:- As below this is the XML bursting File. We need to Design this File in this Format and Then attach to the Concurrent Program data Definitions as per last Step (Step2).

 

Here We give all the Information's about Our SMTP server which will send the email Notifications in the <xapi:email> tag.

 

<xapi:request>  is very important tag in the Bursting. Here I have used the "/XX_REPORT_GROUP1/XX_REPORT_GROUP2/XX_REPORT_GROUP3".  It means my Original Concurrent Program Report (RDF) has three groups with these names and I want to do burst emails as per my Third Group. Groups names should be same as per my Report. I can also use  "/XX_REPORT_GROUP1/XX_REPORT_GROUP2" in the <xapi:request> tag If I want to do burst emails as per my Second report group. You can also this

"/XX_REPORT_GROUP1/XX_REPORT_GROUP2/XX_REPORT_GROUP3" grouping idea from your Concurrent Program XML output. GO to Concurrent Request of the Concurrent Program and View the Output in XML. You can get the idea from there about all reports xml groups names and you can use these names in the Bursting Control File <xapi:request> tag.

 

 

 

Step4:- Now I have attached the Bursting Control file to the Concurrent Program Data Definitions. Now the Next step is to run that Concurrent Program Concurrent Request.

 

 

Step5:- Now Copy the Request Id from Step 4 and Put in the "XML Publisher Report Bursting Program" request id Parameter as below.

 

This will Fire the XML bursting for this Concurrent Program request Output.



 

 

How to send xml publisher report by email to usersl