Bursting in Oracle Fusion Reports

 Showing Sample Query for Bursting

Bursting is used for mailing or faxing or sending report details to others through any media

Steps for Bursting:

Step 1: Create a Data model

I am taking a sample Query

Step 2: Add bursting Definition

Click "Plus" symbol to add bursting definition and under sql query give query

Sample Bursting Query:

select distinct

PERSON_NUMBER as "KEY",

'BITemplate' TEMPLATE,

'en-US' LOCALE,

'PDF' OUTPUT_FORMAT,

'EMAIL' DEL_CHANNEL,

'mail address' PARAMETER1,

'mail address' PARAMETER3,

'Employee details' PARAMETER4,

'Hi, Please find the attached details' PARAMETER5,

'true' PARAMETER6

from (select   distinct PERSON_NUMBER,FULL_NAME,DISPLAY_NAME    

from

per_all_people_f  papf,

per_person_names_f ppnf

where

papf.person_id=ppnf.person_id)

Note:  Since we are using Person Number as Key, each person gets mail.

Step 3: Save Data model and create Report

Step 4: Open Report Properties and enable Bursting option

Step 5: Schedule Report or from Report, click "Send" to send mails