Report Bursting in oracle fusion

Report Bursting in oracle fusion

We do know the Report bursting feature, Report Bursting helps to distribute the Oracle fusion report output through multiple distribution channel like Email, FAX, FTP to the desired recipients. Through Report bursting in oracle fusion, we can split the report output in multiple parts as per our business Requirement and send each report output part through email, Fax, FTP to the desired recipients. Reports bursting feature in oracle fusion helps to bring the automation in the report distribution method and all the distribution process happens automatically. Report Bursting in oracle fusion is feature given in the Oracle BIP reports. We can design the report bursting process as per our business Requirement. Here below I will share the detail steps to explain the report bursting setups  in oracle fusion.

Step by Step Report Bursting in Oracle Fusion

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 !!