Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 4 · BI Publisher: data models, templates and bursting
Bursting: one run, many recipients
Lesson 33 of 177 · 2 min
Bursting splits ONE run into MANY documents with many recipients. One statement job producing four hundred PDFs, each emailed to its own supplier — rather than four hundred scheduled runs, or one PDF somebody has to split by hand. The control is a bursting query, and it returns one row per output document. Each row carries the KEY that splits the data, the template and output format to use, the delivery channel, and the address — an email address, an FTP path, a printer. THE SPLIT KEY MUST MATCH THE GROUPING IN THE DATA MODEL. Burst on supplier and the data model must group by supplier at the level the template repeats over; if the key names a column that appears at a lower level, the split is wrong in a way that produces documents rather than errors. AND THAT IS THE FAILURE TO BE FRIGHTENED OF: EVERYONE RECEIVES EVERYONE…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Oracle Fusion Technical: Reports, Data, Integrations and Extensions, with a certificate on completion and a fourteen-day refund window.
In this module: Module 4 · BI Publisher: data models, templates and bursting
- 1What a data model actually isFree preview
- 2SQL data sets: writing the query
- 3Parameters and lists of values
- 4Bursting: one run, many recipients
- 5RTF templates: the practical subset
- 6Excel and eText templates
- 7Sub-templates and reuse
- 8Layout, pagination and the printed page
- 9Localisation: Arabic, dates and numbers
- 10Performance: making a slow report fast
- 11Security in BI Publisher
- 12Scheduling and delivery
- 13What breaks: five BI Publisher failures
- 14Lab briefing · A supplier statement, end to end