MSAMM
Back to course

Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 4 · BI Publisher: data models, templates and bursting

RTF templates: the practical subset

Lesson 34 of 177 · 2 min

RTF templates have a large syntax and a small practical subset that covers almost everything you will build. Fields place a value: a form field bound to an element name, formatted by the template rather than the query. Loops repeat a block for each row in a group — for-each around a table row is most of every document you will produce. Conditions show or hide a block: a discount line that only appears when there is a discount, an Arabic address block when the customer is Egyptian. Those three plus totals cover the working majority. THE WORD HABITS ARE WHAT PRODUCE A TEMPLATE NOBODY CAN MAINTAIN. Four in particular. Spaces and tabs used as layout instead of a table, which collapses the moment a value is longer than the test data. Manual line breaks holding a block together, which reflow unpredictably. Direct formatting applied character by character rather than

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.

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 4 · BI Publisher: data models, templates and bursting

  1. 1What a data model actually isFree preview
  2. 2SQL data sets: writing the query
  3. 3Parameters and lists of values
  4. 4Bursting: one run, many recipients
  5. 5RTF templates: the practical subset
  6. 6Excel and eText templates
  7. 7Sub-templates and reuse
  8. 8Layout, pagination and the printed page
  9. 9Localisation: Arabic, dates and numbers
  10. 10Performance: making a slow report fast
  11. 11Security in BI Publisher
  12. 12Scheduling and delivery
  13. 13What breaks: five BI Publisher failures
  14. 14Lab briefing · A supplier statement, end to end