xml publisher brusting
Post on 14-Apr-2018
236 Views
Preview:
TRANSCRIPT
-
7/27/2019 XML Publisher Brusting
1/13
2011 IBM Corporation1
XML PublisherBursting
Aug 2013
Devender Yadav
-
7/27/2019 XML Publisher Brusting
2/13
2011 IBM Corporation22
Agenda
Overview of XML Publisher
About XML Publisher Bursting
Usage Scanerios
Case Study Automation of IUC invoice delivery in Bharti Airtel
Pre-req for Implementation
Implementation steps
References
-
7/27/2019 XML Publisher Brusting
3/13
2011 IBM Corporation3
XML Publisher is a state of art reporting technology, its architectureis based on decoupling of data, layout and translation.
Overview of XML Publisher
-
7/27/2019 XML Publisher Brusting
4/13
2011 IBM Corporation
Bursting is feature of XML Publisher engine which enables the splitting ofdata into blocks, generating document for each block and deliver thedocument to one or more destinations.
4
XML Publisher Bursting
https://w3.ibm.com/learning/lati/sites/careersmart/html/cs_planyourdevelopment.htmlhttps://w3.ibm.com/learning/lati/sites/careersmart/html/cs_trackyourprogress.html -
7/27/2019 XML Publisher Brusting
5/13
2011 IBM Corporation
XML Publisher Bursting feature can be used in situation where one largedocument, containing repeating data blocks and each data block need todistributed to individuals e.g
Distribution of Salary hike letters to employees via email.
Automated delivery of customer invoices via email or fax.
Automated delivery of purchase orders via mail or fax.
Distribution of Financial/Business reports in management hierarchy.
Any other rule based distribution of documents.
5
Usage of Bursting
-
7/27/2019 XML Publisher Brusting
6/13
2011 IBM Corporation
Case Study: XML Publisher Bursting implemented in Bharti Airtel fordistribution of IUC invoices to customers.
Business pain areas before implementation:
Printing of invoices
Packing and sending invoice via currier
Time lag in physical delivery of invoice
Cost overhead of printing, packing and delivery
Business Benefits after implementation:
Saving of Invoice processing and dispatch cost on following heads:
Manpower for invoice printing, signing and dispatching of invoice
Cost of paper, printing, dispatch
Remove the time lag due to manual invoice delivery, will help in better fund management
and collection from the party.
This functionality should certainly add operational excellence to the process and will fasten
the process of the invoice delivery to the customers. Appreciate the efforts of your team and
a quick turn around on this.
Nitin Tayal, General Manager, Bharti IT
6
-
7/27/2019 XML Publisher Brusting
7/13 2011 IBM Corporation
Assuming that documents need to delivered via email, then followingare implementation prerequisites.
A concurrent program generating the consolidated output.
XML data tag, on which splitting is required
IP address and port of SMTP Server
Email address of From, Reply to
XML data tag representing email address for TO, CC
Email subject and email body
77
Implementation Prerequisites
-
7/27/2019 XML Publisher Brusting
8/13 2011 IBM Corporation
Bursting control file is configuration file that governs the XMLPublisher Bursting.
8
Implementation
-
7/27/2019 XML Publisher Brusting
9/13 2011 IBM Corporation
tag tells busting engine, bursting should bedone at the occurrence of which tag ?
We want Bursting to happen at each
occurrence of tag G_INVOICE
9
-
7/27/2019 XML Publisher Brusting
10/13 2011 IBM Corporation
tag tells bursting engine, which delivery mechanismto be used and on what condition ?
For Email
10
-
7/27/2019 XML Publisher Brusting
11/13 2011 IBM Corporation
Details end to end steps implementation steps for using XMLPublisher Bursting.
Build the Data Logic as per the business requirements
Deploy the data logic to the server
Register the concurrent Executable
Register the Concurrent program with output type as 'XML
Run Concurrent program and it will generate the output as XML file
Using the XML file generated above, Build the layout as RTF for the data structure using MS-
Word.
Build the Bursting Control File by considering the XML tags generated
Define the Data Definition using the XML Publisher responsibility and attach Bursting Control
file.
Define the Template
Run Concurrent program
Run XML Publisher Report Bursting Program and pass the request id of the completed
concurrent program as input parameter.
11
-
7/27/2019 XML Publisher Brusting
12/13
2011 IBM Corporation
Use the following code in after report trigger to invoke the XMLPublisher Report Bursting program automatically.
v_bursting_request_id := APPS.FND_REQUEST.SUBMIT_REQUEST('XDO',
'XDOBURSTREP',
NULL,
NULL,
FALSE,
'Y',
V_req_id, --Parent programs request id
'Y');
12
-
7/27/2019 XML Publisher Brusting
13/13
2011 IBM Corporation
References
User guide http://docs.oracle.com/cd/B15436_01/current/acrobat/115xdoug.pdf
Blogs
http://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisher
https://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-
bursting-to-send-xml-report-via-email
http://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-
publisher.html
http://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentation
13
http://docs.oracle.com/cd/B15436_01/current/acrobat/115xdoug.pdfhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://www.slideshare.net/ediyanto83/oracle-xml-publisher-bi-publisher-presentationhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttp://oracleappstechnofunctionalstuff.blogspot.in/2012/01/bursting-concept-in-xml-publisher.htmlhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttps://sites.google.com/site/shareapps4u/learning-topic/xml-publisher/how-to-use-xml-bursting-to-send-xml-report-via-emailhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://apps2fusion.com/at/49-cp/250-bursting-in-xml-bi-publisherhttp://docs.oracle.com/cd/B15436_01/current/acrobat/115xdoug.pdf
top related