Bursting Setup in Oracle cloud BIP Reports : How to do Bursting in Oracle Fusion BIP Reports

Bursting Setup in Oracle cloud BIP Reports : How to do Bursting in Oracle Fusion BIP Reports

Bursting is the process in which we can split and send the report output though Email or Fax automatically. Bursting helps to burst the report output. If we want to sent the report output through some logic to our customer then we can do this with the help of Bursting. Bursting works based on the report output and then based on our logic it split the report output and then send to the customers or any email address. In Oracle Cloud , Like EBS we have the Bursting Feature in Reports system. Here below I will share the detail Bursting Setup in Oracle cloud BIP Reports

 

Step by step Bursting in Oracle Fusion BIP Reports

Step1:- First thing I am assuming , we know the BIP reporting tool in Oracle cloud. If you are familiar with BIP in Oracle Fusion then you can refer my OLD posts.

 

Step2:- Go to the BIP report Data Model to which we want to do the Bursting.

 

Step3:- For Example , here below is the Report Data Model and i want to Create the Bursting according to the vendor.

 

Like Report output should Split and send according to the supplier basis so here below VENDOR_ID is the important column of this report and we will use this column to split the report output for different suppliers.

 

 

Step4:- In the report Data Model , We need to go to Bursting Open as highlighted below.

 

 

 

Step5:- Now click on the '+' icon to create the bursting Logic for this report.

 

 

Step6:- Here below we are designing the Bursting logic in Cloud BIP reports.

 

Split By and Delivery By are the Two important Parts in Designing the Bursting Logic.

 

Split By means , We can to divide the reports output on the basis of which column of the report. For Example , We will use Vendor_id column so that report output will be split based on the Vendor and if the report output having 3 suppliers output then Bursting First divide/split this report output in 3 parts based on Vendor Id.

 

Delivery By means , This is uses to sent the report output through Email. Here also we need to specify the report column based on which we want to delivery the report output.

 

Split By is the Parent Column and Deliver by is the child Column of this Parent Split by Column.

 

So Bursting email deliver logic works on the basis of Deliver By.

 

 

 

 

Step7:- Here below i have used the common Vendor_ID column of the report in Split By & Deliver By logic.

 

Split By and Delivery By are the Two important Parts in Designing the Bursting Logic.

 

Split By means , We can to divide the reports output on the basis of which column of the report. For Example , We will use Vendor_id column so that report output will be split based on the Vendor and if the report output having 3 suppliers output then Bursting First divide/split this report output in 3 parts based on Vendor Id.

 

Delivery By means , This is uses to sent the report output through Email. Here also we need to specify the report column based on which we want to delivery the report output.

 

Split By is the Parent Column and Deliver by is the child Column of this Parent Split by Column.

 

So Bursting email deliver logic works on the basis of Deliver By.

 

In the SQL Query we will use this below SQL Query

 

select

Vendor_id as "KEY",

'RTF NAME OF THE BIP REPORT.rtf' TEMPLATE,

'en-US' LOCALE,

'PDF' OUTPUT_FORMAT,

VENDOR_NAME OUTPUT_NAME,

'EMAIL' DEL_CHANNEL,

'To Email Address' PARAMETER1,

'Cc Email Address' PARAMETER2,

'TestEmail.email.com PARAMETER3',

'Subject Of the Email' PARAMETER4,

'Hi

 

'||'Email body which will be show in the Bursting Email.

'||'Thanks & Regards

Test Person' PARAMETER5,

'True' PARAMETER6,

:p_from_email  PARAMETER7

from PO_VENDORS

 

 

 

Step8:- Here below is the final Bursting Logic written in the BIP report.

 

 

 

 

This is the Final step and code to design the Bursting in the Oracle Cloud BIP reports. Thanks !!

 

 

Bursting Setup in Oracle cloud BIP Reports : How to do Bursting in Oracle Fusion BIP Reports