Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 4 · BI Publisher: data models, templates and bursting
Parameters and lists of values
Lesson 32 of 177 · 2 min
Parameters are what make a report answer a FAMILY of questions rather than one. One supplier statement definition serving every supplier, one period definition serving every month. A parameter becomes a BIND VARIABLE in the query — :P_PERIOD — and the binding is what keeps it safe and fast: the value is passed rather than concatenated, so it neither breaks on an apostrophe in a supplier name nor invites the injection that string-building would. A LIST OF VALUES turns a parameter into a choice rather than a typing exercise. It is its own small query, and the two decisions worth making deliberately are whether it is filtered to what the user may see — an unfiltered list of business units tells a user which ones exist — and whether it is short enough to display, because a list of fifty thousand customers is a text box with extra steps. THE…
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