Am I the only one who finds bursting to be extremely frustrating and arcane?

Scott Paulin

Summary

I need a working sample - please help

Content

I have been scouring Oracle forums for a week to find working samples.  I have tried following the arcane instructions, but nothing is working for me

Umamaheswara Reddy Karri

Hi Scott,

Can you let us know your exact requirement.  Like, Do you want to burst and distribute entire output file as a single file OR want to generate multiple files based on some key value? what is your delivery method? i.e. Email or FTP? Based on these details, we can provide you a sample bursting query.

Thanks,

UIma

 

Scott Paulin

Thank you.  Eventually, I did get a sample to work through trial and error.

Arghyo Banerjee -Oracle

Hi Scott,

Hope this helps

Q What is Bursting ?

A Bursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations

Below is a step by step use case to explain the process

Steps 1. Create a Data Model with a bursting Query

a. Create a Data Set

================================

Data Source : ApplicationDB_FSCM

Use the sample Query

Select * from DOO_HEADERS_ALL
where STATUS_CODE = 'OPEN'
AND rownum<4

Aim : The output of this query is three rows with three different order number . Our Aim is to split this in to three reports containing Single Order in each  Hence we selected KEY as ORDER NUMBER

b. Create a Bursting Query

==================================

Select ORDER_NUMBER  AS "KEY",  -- It must be same as deliver by
'Test.rtf' TEMPLATE, -- Fusion Report template name--
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT,
'EMAIL'  DEL_CHANNEL,
'abc@email.com' PARAMETER1,  -- to mail address   (use a valid Email Address)---
'geh@email.com' PARAMETER2, -- cc email address (use a valid Email Address)--
'sggf@email.com'  PARAMETER3,----From Email Address(use a valid Email Address)---
'Your Order Details' PARAMETER4,-- Email Subject--
'Please find attached your Order Details' PARAMETER5,-- Email body --
'true' PARAMETER6,--Attachment value ('true' or 'false'). If your output format is PDF, you must set this parameter to "true" to attach the PDF to the e-mail.
'tgfgg@email.com' PARAMETER7-- reply-to mail address(use a valid Email Address)---

from DOO_HEADERS_ALL
where STATUS_CODE = 'OPEN'

AND rownum<4

 

c. Save the data Model and export the XML

Step 2 : Create a RTF template with the help of the XML exported . Create a Report based on this RTF Template (Test.rtf)

Step 3: Edit the Report > Go to Properties (Right hand side of the page) > Check Enable Bursting under Advanced

Step 4: Schedule the Report and you will receive three mails in your mail as per the given bursting query

NOTE : Use the same format as suggested in the Bursting query for correct result