Oracle BI Publisher training
Pixel-perfect documents and scheduled reports from Oracle Fusion data.
- Duration
- 24 hours
- Level
- Intermediate
- Modules
- 5 modules · 5 hands-on labs
- Delivery
- Live virtual or on-site
- Group size
- Up to 12 participants
- Environment
- Your own test pod
- Pricing
- Contact us for a tailored quote
About this course
BI Publisher is how Fusion produces invoices, checks, purchase orders, bank files and most custom reports. Participants write SQL data models over Fusion tables, design RTF, Excel and eText layouts, and set up scheduling and bursting so reports reach the right people automatically.
Who it’s for
Report developers, technical consultants and power users who write SQL.
Prerequisites
Basic SQL, and BI Publisher privileges in your Fusion test pod.
Afterwards, your team can
- Build data models that perform on large volumes
- Customise seeded documents without breaking upgrades
- Automate scheduled and burst delivery
- Move reports between environments reliably
Course outline
5 modules over 24 hours. We adjust the depth and examples to the people in the room.
-
01
BI Publisher in Fusion
- Catalog, folders and permissions
- Data models, reports and layouts
- Where seeded reports live and how to customise them safely
-
02
Data models
- SQL data sets over Fusion tables and views
- Parameters and lists of values
- Groups, links and aggregations
-
03
Layouts
- RTF templates with Template Builder for Word
- Excel templates
- eText for bank and EFT files
- Sub-templates for shared headers and logic
-
04
Scheduling and bursting
- Scheduling reports and Enterprise Scheduler jobs
- Bursting by supplier, customer or business unit
- Delivery by email, FTP and content server
-
05
Performance and deployment
- Tuning slow queries
- Data security in custom reports
- Archiving and moving reports between pods
Labs in your own test pod
Participants practise on your configuration and data, so what they learn carries straight into their day-to-day work.
- Write a supplier payments data model
- Design an RTF remittance advice
- Build an Excel output
- Burst by supplier and email
- Migrate a report to another pod
How the training runs
Format
Live virtual or on-site, fully customisable and scheduled around your team’s calendar
Group
Private cohorts of up to 12 participants. Larger teams are split into separate groups.
Environment
Your own test pod, with your configuration and data
You keep
Course presentations (PPT), workbook and lab guides
Frequently asked questions
Who is the Oracle BI Publisher course for?
Report developers, technical consultants and power users who write SQL.
How long is the Oracle BI Publisher course?
24 hours of instructor-led training. We split it into sessions that fit around your team’s calendar.
What do participants need beforehand?
Basic SQL, and BI Publisher privileges in your Fusion test pod.
Is the training virtual or on-site?
Both. Most courses run as live virtual sessions, and we can deliver on-site when that suits your team better.
How much does the Oracle BI Publisher course cost?
Pricing depends on the course structure we build with you, including the modules, depth and number of groups. Contact us and we’ll send a tailored outline and quote.
Is the training delivered on our own Oracle environment?
Yes. Labs run in your own test pod, so participants practise on your configuration and data rather than a generic demo.
How many people can attend?
Up to 12 participants per group. Larger teams are split into separate groups so everyone gets hands-on time.
What do participants keep after the course?
The course presentations (PPT), workbook and lab guides.
Keep exploring
Consulting service OTBI & BI Publisher servicesPlan Oracle BI Publisher training for your team.
Tell us who you’d like to train and what they need to do afterwards. We’ll come back with a tailored outline and schedule.
Request this course