BI Publisher Bursting in Oracle Fusion

• Bursting is the method of automatically splitting and submitting the report output via email or fax. 
• Bursting aids in the output of the report. With the aid of Bursting, we can send the report output to our customer after running it through some logic. 
• Bursting operates by splitting the report output according to our logic and then sending it to the customers or some email address. We have the Bursting Functionality in Reports framework in Oracle Cloud, just like EBS. 

I’ll go into the Bursting Configuration in Oracle Cloud BIP Files in depth below.

BIP Bursting Steps in Oracle Fusion

1. Create a BIP Data Model based on SQL queries.
2. From the SQL Data Model, create a BIP Report.
3. Go to the Data Model for the BIP report that we want to burst.
4. The report data model as seen below, and I’d like to build the bursting according to the vendor’s guidance. As an example, the report output can be divided and sent according to the supplier, so the important column of this report is VENDOR_ID, which we will use to split the report output for different suppliers.
5. We need to go to Bursting Open in the report Data Model, as seen below.
6. To build the bursting Logic for this report, press the ‘+’ button.
7. Oracle has designed Fusion BIP Bursting logic in two parts (1) Split by (2) Deliver by

Split By: By using split by method we can divide the output of the reports based on which column of the report we’re looking at. For example, we would use the Vendor_id column to split the report output by vendor, and if the report output has three vendors, Bursting will divide and split the report output into three parts based on Vendor_Id.

Deliver By: Deliver by method is used to submit the report output via email. We must also define the report column depending on which the report output should be delivered.

The parent column is ‘Split By‘ and the child column is ‘Deliver By‘ , Bursting email deliver logic is based on ‘Deliver By‘.

8. In the Split By and Deliver By LOV, I used the report’s common Vendor_ID column.

9. We’ll use the SQL Query below in the SQL Query block.

SELECT

               VENDOR_ID AS "KEY",

              'BIP_REPORT_RTF_NAME.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,

                'The Emails Subject' PARAMETER4,

                'Hi

                '||'The body of the email that will be reflected in the Bursting Email.

                '||'Thanks & Regards

                Person Name' PARAMETER5,

                'True' PARAMETER6,

                :p_from_email  PARAMETER7

FROM PO_VENDORS;

10. The final Bursting Logic written in the BIP report is shown below.

How to create dependent LOV in Oracle Fusion BI Reports

 

Steps

1. Create a Data Model with SQL query
2. Create 2 list of values(LOV), pass parameter in dependent LOV query.
3. Create 2 Parameters, select their respective list of value(LOV).
4. Save the Data Model.
5. Run BIP Report, Dependent LOV is changing based on Independent values.




For Example: We are creating 2 parameters and when the independent LOV value changes, the dependent LOV changes as well.

1. Header_ID : Independent Parameter
2. Line_ID: Dependent Parameter

(1) Create a Data Model

Navigation:  Navigator > More > Report and Analytics > Browse Catalogue > New > Data Model

Data Model SQL Query: 

Select PO_Header_id, Type_lookup_code, segment1,Vendor_id

From PO_Headers_all;

(2) Create 2 list of values(LOV)

Create 2 list of values, one is independent and another one will dependent, pass parameter in dependent list of value SQL query



Write SQL query for each list of Value(LOV)



Pass parameter values in SQL query for dependent LOV



(3) Create 2 Parameters



Select highlighted options for both parameters



(4) Save the BIP Report

Click on Save icon from the right top of the window and choose the location where you want to save the data model.

(5) Run BIP Report

To run the BIP report click on View Data button from the right top window screen, choose any Header_ID from the first LOV and you will find second parameter Line_ID list of values are changing.