In this article i will give an overview of Bursting in BI Publisher (Formerly XML Publisher ) and the Pre requisites to enable Bursting .
Background / Business Requirement for Bursting
In Oracle Purchasing we have PO Print Report which can be used to print new or selected Purchase order. Organizations usually schedule this program on a daily basis to print new purchase orders. If we want to integrate this Oracle Report to XML/BI Publisher to create eye candy layouts and email the PO automatically to the suppliers, the common issue we face is, How to split the XML file created by the report .This is because the report will create a single XML file consisting of the all the PO selected and if we apply the template on this XML file it will create a single PDF file consisting of all the PO's, and we definitely don’t want purchase orders sent to a supplier which is not related to him .
If we have to send PO to individual supplier there has to be a way to parse the XML file generated from the PO Print Report.After parsing the XML file we can break the XML into smaller chunks based on the PO Number and then email the PO to respective Suppliers.
<!--[endif]-->Advantages of XMLP bursting
<!--[if !supportLists]-->a. <!--[endif]-->No Additional Coding, just need to create XML bursting File. ( Isnt it exciting , otherwise we would have to write java program to split the XML File and then use XMLP delivery manager API to send emails .
<!--[if !supportLists]-->b. <!--[endif]-->Process of Creating XML data Definition and Template remains AS – IS .
<!--[endif]-->Prerequisites
<!--[if !supportLists]-->a. <!--[endif]-->Apply patch 5968876 if not already applied
<!--[if !supportLists]-->b. <!--[endif]-->Verify XMLP version is 5.6.3
<!--[if !supportLists]--> i. <!--[endif]-->Steps to Verify
<!--[if !supportLists]-->1. <!--[endif]-->adident Header $OA_JAVA/oracle/apps/xdo/common/MetaInfo.class
Below matrix shows the version you are and the patch to be applied to come to 5.6.3
Metainfo.class |
|
Patch | Reference | |
120.6 | XDO 5.6.3 | Patch 4440000 | ||
... for the Oracle E-Business Suite 11i | ||||
115.28 | XDO 5.6.3 | Patch 5472959 | Note 422508.1 | |
115.27 | XDO 5.6.2 (core) | Patch 5097966 | Note 367394.1 | |
115.26 | XDO 5.6.1 | Patch 4905678 | Note 357308.1 | |
115.24 | XDO 5.6.0 | Patch 4561451 | Note 337999.1 | |
115.22 | XDO 5.5.0 | Patch 4206181 | Note 316447.1 | |
115.21 | XDO 5.0.1 (core) | Patch 4236958 | ||
115.19 | XDO 5.0.0 | Patch 3822219 | Note 295036.1 | |
c. <!--[endif]-->Set Temporary Directory in the XML Publisher Administraor- > Administration- > General to a directory to which you have write permission .
<!--[if !vml]--><!--[endif]-->
d. After the Patch is applied we will see a new Bursting control file button in the XML Publisher Data Definition Page
In the next article, we will see how to create a bursting XML file and how everything fits together.