Oracle Fusion OTBI & BI Publisher Training

Oracle Fusion OTBI & BI Publisher Course Curriculum

Module 1 — Oracle Fusion Reporting Fundamentals

• Introduction to Oracle Fusion Cloud reporting
• Oracle Fusion reporting architecture
• Reports and Analytics
• OTBI overview
• BI Publisher overview
• OTBI vs BI Publisher
• Analytical reporting vs operational reporting
• BI Catalog
• Reports and Analytics navigation
• Reporting roles and privileges
• Reporting security fundamentals

Module 2 — OTBI Fundamentals

• Introduction to Oracle Transactional Business Intelligence
• OTBI architecture and concepts
• Subject Areas
• Dimensions
• Facts
• Measures
• Attributes
• Folders and columns
• Selecting the appropriate Subject Area
• Understanding transactional data
• Creating an OTBI Analysis

Module 3 — Creating OTBI Analyses

Learn how to create and customize interactive Oracle Fusion analyses.

• Creating analyses
• Selecting columns
• Sorting
• Filtering
• Prompts
• Column formulas
• Calculated measures
• Aggregation
• Conditional formatting
• Groups and bins
• Table views
• Pivot views
• Exporting analysis results

Practical Exercises

Participants create reports such as:

• Employee analysis
• Department-wise employee report
• Job-wise employee report
• Location-wise analysis
• Management reporting

Module 4 — Advanced OTBI Reporting

• Advanced filters
• Selection Steps
• Column selectors
• View selectors
• Drill-down reports
• Drill-through functionality
• Master-detail relationships
• Compound layouts
• Calculated fields
• Dynamic report titles
• Conditional display
• Cross-subject-area reporting
• Advanced report formatting

Module 5 — OTBI Dashboards

Learn how to convert individual analyses into interactive business dashboards.

• Introduction to OTBI dashboards
• Creating dashboards
• Dashboard pages
• Adding analyses
• Dashboard prompts
• Page-level prompts
• Filters
• Interactive dashboards
• Dashboard navigation
• Adding BI Publisher content
• Dashboard security

Practical Dashboard Project

Build an Oracle Fusion HR Dashboard containing:

• Employee headcount
• Department-wise employee count
• Location-wise employee count
• New hires
• Employee trends
• Interactive prompts
• Dashboard filters

Module 6 — OTBI Agents & Automated Reporting

• Introduction to OTBI Agents
• Creating Agents
• Scheduling analyses
• Conditional Agents
• Alerts
• Notifications
• Email delivery
• Report subscriptions
• Managing scheduled reports

BI Publisher Training

Module 7 — BI Publisher Fundamentals

• Introduction to Oracle BI Publisher
• BI Publisher architecture
• BI Publisher Catalog
• Data Sources
• Data Models
• Report definitions
• Report layouts
• Output formats
• PDF reports
• Excel reports
• CSV reports
• Running reports in Oracle Fusion

Module 8 — BI Publisher Data Models

• Data Model Editor
• SQL Data Sets
• Parameters
• Bind variables
• Lists of Values
• Multiple Data Sets
• Data Set joins
• Data triggers
• XML output
• Generating sample XML
• Testing Data Models
• Troubleshooting Data Models

Module 9 — SQL for Oracle Fusion Reporting

Develop the SQL skills required for BI Publisher reporting.

• SQL fundamentals
• SELECT statements
• WHERE conditions
• ORDER BY
• GROUP BY
• Aggregate functions
• Inner Joins
• Outer Joins
• Subqueries
• CASE statements
• Date functions
• String functions
• Numeric functions
• Report parameters
• Bind variables
• Writing SQL for business reports

Practical SQL Exercises

Participants develop reporting queries for:

• Employee information
• Departments
• Suppliers
• Invoices
• Purchase orders
• Payroll-related information

Module 10 — BI Publisher Report Development

• Creating BI Publisher reports
• Connecting Data Models
• Report properties
• Report parameters
• Parameter-driven reports
• Grouping
• Sorting
• Aggregation
• Conditional logic
• Page breaks
• Headers and footers
• No-data handling
• Multiple output formats

Module 11 — RTF Template Development

Learn how to create professional BI Publisher report layouts using Microsoft Word and RTF templates.

• Microsoft Word and BI Publisher Template Builder
• Creating RTF templates
• XML field mapping
• BI Publisher tags
• for-each
• if conditions
• choose conditions
• Variables
• Calculations
• Formatting
• Grouping
• Nested groups
• Page breaks
• Repeating headers
• Conditional sections
• Dynamic content

Module 12 — Advanced BI Publisher

• Master-detail reports
• Subtemplates
• Style templates
• Dynamic logos
• Dynamic columns
• Multiple layouts
• Excel templates
• Multi-sheet Excel reports
• Hyperlinks
• Images
• Barcode reporting
• Multilingual reporting
• Report translations

Module 13 — BI Publisher Bursting

Learn how to automatically generate and distribute reports to different recipients.

• What is report bursting?
• Bursting architecture
• Bursting queries
• Single-file bursting
• Multi-file bursting
• Dynamic recipients
• Email delivery
• File delivery
• FTP/SFTP delivery
• Dynamic email subjects
• Multiple recipients
• Testing bursting

Practical Bursting Project

Develop an automated report distribution solution that generates individual reports for different employees, suppliers, customers or business units and distributes them to designated recipients.

Module 14 — Scheduling & Scheduled Processes

• Scheduling BI Publisher reports
• Scheduled Processes
• ESS Jobs
• Report parameters
• Recurring schedules
• Output management
• Email notifications
• Managing scheduled reports
• Troubleshooting scheduled reports

Module 15 — OTBI & BI Publisher Integration

• Combining OTBI and BI Publisher
• Adding BI Publisher reports to dashboards
• Analytical vs operational reporting
• Choosing OTBI or BI Publisher
• Using OTBI and BI Publisher together
• Designing Oracle Fusion reporting solutions

Module 16 — Oracle Fusion Reporting Security

• Reporting security
• Roles and privileges
• Data access
• Catalog permissions
• Folder security
• Report security
• User access
• Troubleshooting reporting access

Practical Oracle Fusion Reporting Projects

The course is designed around practical reporting scenarios rather than only theoretical concepts.

Project 1 — Employee Information Report

Develop an employee report containing:

• Employee name
• Employee number
• Department
• Job
• Location
• Manager
• Hire date

Project 2 — HR Analytics Dashboard

Create an interactive OTBI dashboard containing:

• Headcount
• Department-wise employees
• Location-wise employees
• New hires
• Employee trends
• Interactive prompts
• Filters

Project 3 — Payroll Report

Develop a payroll-oriented report containing:

• Employee
• Department
• Earnings
• Deductions
• Net salary
• Payroll period

Project 4 — Supplier & Invoice Report

Create a BI Publisher report containing:

• Supplier
• Invoice number
• Invoice date
• Business Unit
• Invoice amount
• Tax
• Payment status

Project 5 — Procurement Report

Develop a purchase-order report containing:

• PO number
• Supplier
• Buyer
• Business Unit
• PO amount
• Approval status

Project 6 — Pixel-Perfect Invoice

Develop a professional BI Publisher invoice containing:

• Company logo
• Customer details
• Invoice information
• Invoice lines
• Tax
• Totals
• Page formatting
• PDF output

Project 7 — Automated Report Bursting

Build an automated reporting solution that:

• Generates individual reports
• Identifies recipients dynamically
• Creates separate output files
• Sends reports through email
• Uses scheduled execution

Learning Outcomes

After completing the Oracle Fusion OTBI & BI Publisher Training, participants will be able to:

• Understand Oracle Fusion reporting architecture
• Select appropriate OTBI Subject Areas
• Create OTBI analyses
• Develop advanced OTBI reports
• Create interactive dashboards
• Use filters and prompts
• Create calculated measures
• Develop BI Publisher Data Models
• Write SQL queries for reporting
• Create parameterized reports
• Develop RTF templates
• Create PDF and Excel reports
• Schedule reports
• Configure report bursting
• Automate report distribution
• Understand reporting security
• Troubleshoot common reporting issues
• Develop practical Oracle Fusion reports and dashboards

Who Should Take This Oracle Fusion Reporting Course?

This course is suitable for:

• Oracle Fusion consultants
• Oracle Technical Consultants
• Oracle Functional Consultants
• Oracle HCM professionals
• Oracle Financials professionals
• Oracle SCM professionals
• Oracle ERP professionals
• Business analysts
• Reporting analysts
• MIS professionals
• SQL developers
• BI professionals
• ERP professionals
• IT professionals
• Fresh graduates interested in Oracle reporting
• Working professionals looking to develop Oracle Fusion reporting skills

Prerequisites

No advanced programming background is required. A basic understanding of Oracle Fusion, ERP or business processes is helpful but not mandatory. Basic SQL knowledge is beneficial, particularly for BI Publisher Data Models and advanced reporting. Professionals from HCM, Financials, SCM, Procurement, Payroll, ERP, Business Intelligence and reporting backgrounds can benefit from this course.

Oracle Fusion OTBI & BI Publisher Training Online

Live Online Training for Participants Worldwide

Palium Skills offers Live Online Oracle Fusion OTBI & BI Publisher Training for participants across different countries and regions. Participants can join instructor-led sessions remotely without relocating. The online program is suitable for:

• Individual learners
• Working professionals
• Oracle consultants
• International students
• Corporate teams
• Career switchers

International Regions

Training is available for participants from: India | USA | UK | Middle East | Africa | Asia-Pacific The program can be scheduled around suitable time zones depending on the batch.

Oracle Fusion OTBI Training for Participants in India

Participants based in India can choose between: Live Online Training or Classroom Training in Kolkata The same core curriculum can be delivered through either format.

Oracle OTBI & BI Publisher Training in Kolkata

For participants looking for Oracle OTBI Training in Kolkata, Palium Skills provides classroom training at its Kolkata centers.

South Kolkata Center

Sheeba Bhavan, Poddar Nagar Near South City Mall Kolkata – 700068

Salt Lake Center

RDB Boulevard Salt Lake Electronic Complex Kolkata – 700091

Flexible Training Options

Live Online Training

Suitable for participants from India and international locations.

Classroom Training

Available for participants in Kolkata.

Weekday Batches

Suitable for participants who prefer accelerated weekday training.

Weekend Batches

Suitable for working professionals.

Corporate Training

Customized Oracle Fusion reporting programs can be designed for corporate teams.

Why Choose This Oracle Fusion Reporting Course?

Learn OTBI and BI Publisher Together

Instead of learning only one reporting technology, participants develop skills across OTBI and BI Publisher.

Practical Project-Based Training

The curriculum includes real-world reporting scenarios covering HR, payroll, finance, procurement, suppliers and invoices.

SQL for Reporting

SQL is incorporated into the BI Publisher curriculum to help participants understand Data Models and advanced reporting.

Global Online Training

Participants from India, USA, UK, Middle East, Africa and Asia-Pacific can attend Live Online sessions.

Flexible Learning

Choose online training or classroom training in Kolkata.

Career-Focused Curriculum

The program includes practical assignments, projects and interview-oriented scenarios.

Course Duration

40–50 Hours The exact schedule may vary depending on the participant's background, batch structure and practical project requirements.

Oracle Fusion OTBI & BI Publisher Course Fee

Standard Course Fee

Batch pricing of ₹25,000 The standard course includes:

• Instructor-led training
• OTBI training
• BI Publisher training
• SQL for reporting
• Practical assignments
• Real-world projects
• Dashboard development
• Data Model development
• RTF template development
• Scheduling
• Bursting
• Interview preparation
• Course completion certificate

International Participants

International participants can contact Palium Skills for international pricing and payment options.

Corporate Training

Customized corporate training packages are available based on batch size, duration and training requirements.  

Start Your Oracle Fusion Reporting Journey

Build practical skills in: Oracle Fusion OTBI | BI Publisher | SQL | Dashboards | Data Models | RTF Templates | Scheduling | Bursting Join Palium Skills for instructor-led Oracle Fusion OTBI & BI Publisher Training Online and develop reporting skills applicable to Oracle Fusion environments across HCM, Financials, SCM and other business functions. Live Online Worldwide | Classroom Training in Kolkata India | USA | UK | Middle East | Africa | Asia-Pacific Phone: 8420594969 WhatsApp: 9903130500

Related Courses:

Courses that will help you develop a deeper understanding of Oracle Fusion stack are -

• Oracle Fusion Technical Training
• Oracle SQL Training
• Oracle Pl-SQL Training
• Oracle Fusion HCM Training
• Oracle Fusion Finance Training
• Oracle Fusion SCM Training

Get Ready to Launch Your Fusion Career!

Course Name	Delivery Mode	Fee	Special Offer
OTBI & BI Publisher Training Course	Classroom/ Live Online/ Hybrid	₹25,000	Duration: 2 months
OTBI & BI Publisher	Classroom/ Live Online/ Hybrid	$350	Duration: 2 months