I need a working sample - please help
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
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
Thank you. Eventually, I did get a sample to work through trial and error.
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
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…
