XML bursting example in oracle apps r12

XML bursting example in oracle apps r12

Here in this Post , I will share the XML bursting example in oracle apps r12. I will try to design XML bursting file for one standard GL account analysis program. This Bursting Will help to burst the output of this program in to emails. This is complete Working example of XML bursting in oracle apps 12.

 

Example of XML bursting in oracle apps r12

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.