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

    

Installing ADF Desktop Integration for Oracle Fusion Spreadsheet Loads

 To work with spreadsheet loads, we need to install ADFDI installer

Downloading and Installation Steps:

Login to any Fusion Application

Navigator > Tools > Download Desktop Integration Installer

After downloading, install it.

After installing, enable this add in in Microsoft Excel

To enable it, Open Excel > File > Options

In Excel Options, go to Add Ins

Select COM Add ins in "Manage" drop down 

Click on "Go"

A small pop-up appears, Enable "Oracle ADF 11g Desktop Integration Add-in for Excel" and click on Add