How to run a bursting query in Oracle Fusion

How to run a bursting query in Oracle Fusion

Hi friends, we are going to discuss about the bursting query in oracle fusion. We will share the detail sql query for the bursting which we do use in the BIP report to trigger the bursting in oracle fusion. In this post , We will be try to share the complete bursting steps in more detail which can help you to learn and implement the bursting feature in oracle fusion. 

What is Bursting in Oracle Fusion ?

Bursting helps to 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.

Complete Bursting query in Oracle Fusion

Here below, We are sharing the detail bursting query which we do use in the BIP report. You can refer this query and make the changes as per your Requirment.

select

Vendor_id as "KEY",

'RTF LAYOUT 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 Dear

 

'||'Email Message body which we want to show in the Bursting Email.

'||'Thanks & Regards

Test Person' PARAMETER5,

'True' PARAMETER6,

:p_from_email  PARAMETER7

from PO_VENDORS

In this query, we are using the 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:-

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

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.

 

Steps to Implement the bursting query in Oracle Fusion

Here below, I will share the detail steps to use the Bursting in oracle fusion bip reports.

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

 

Step2:- Let suppose , Here below is the Report Data Model and i want to Create the Bursting according to the Supplier.

 

Like Report output should Split and send according to the vendor 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.

 

How to run a bursting query in Oracle Fusion

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

 

How to run a bursting query in Oracle Fusion

 

 

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

 

How to run a bursting query in Oracle Fusion

 

Step5:- 

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.

 

How to run a bursting query in Oracle Fusion

 

 

 

Step6:- In this case , we are using 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

 

How to run a bursting query in Oracle Fusion

 

 

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

 

How to run a bursting query in Oracle Fusion