Create OTBI Reports in Fusion

Introduction

Creating OTBI Reports in Oracle Fusion Financials is one of the most essential skills for any consultant working with reporting and analytics. In real-time implementations, business users rarely depend only on standard reports—they demand customized, real-time insights. That’s exactly where OTBI (Oracle Transactional Business Intelligence) becomes a powerful tool.

In modern Oracle Fusion Cloud (26A release), OTBI allows you to build real-time, subject-area-based reports without technical coding, enabling finance teams to make faster decisions.

From my implementation experience, almost every Finance project requires at least 20–50 custom OTBI reports—ranging from Payables aging to GL balances and Receivables analysis.

What is OTBI in Oracle Fusion Financials?

OTBI (Oracle Transactional Business Intelligence) is a real-time reporting tool embedded within Oracle Fusion applications, allowing users to create reports directly on transactional data without needing a data warehouse refresh.

Key Characteristics

Think of OTBI as a business-friendly reporting layer built on top of Oracle Fusion Financials.

Key Features of OTBI Reports

1. Real-Time Reporting

Unlike BI Publisher, OTBI works directly on transactional tables, so no waiting for ESS jobs.

2. Subject Area Driven

Each module (GL, AP, AR, FA) provides subject areas.

Examples:

• Financials – General Ledger Real Time
• Payables Invoices – Transactions Real Time
• Receivables – Transactions Real Time

3. Drill-Down Capability

Users can drill from summary to transaction-level details.

4. Role-Based Data Security

Security is inherited from Fusion roles.

5. Ad-hoc Analysis

Business users can create their own reports without IT dependency.

Real-World Business Use Cases

Use Case 1: Accounts Payable Aging Report

A client wanted real-time visibility of:

• Pending invoices
• Supplier-wise outstanding

Solution:

• OTBI report using Payables Invoices Real Time
• Filters applied for unpaid invoices

Use Case 2: General Ledger Balance Analysis

Finance team needed:

• Account balances by period
• Drill-down to journals

Solution:

• Subject Area: GL Balances Real Time
• Hierarchical filters on account segments

Use Case 3: Receivables Customer Outstanding

AR team required:

• Customer-wise receivables
• Aging buckets

Solution:

• OTBI with calculated columns for aging logic

Architecture / Technical Flow

OTBI uses a layered architecture:

1. Transactional Database (Fusion Tables)
2. BI Server (RPD Layer)
3. Subject Areas
4. OTBI Analysis UI

Flow:

• User selects subject area
• BI server translates logical query to SQL
• Data fetched in real-time

Prerequisites

Before creating OTBI reports, ensure:

• Appropriate roles assigned:
  • BI Author Role
  • Financial Analyst Role
• Access to:
  • Reports and Analytics
• Understanding of:
  • Subject Areas
  • Business requirements

Step-by-Step: Create OTBI Report in Oracle Fusion Financials

Step 1 – Navigate to OTBI

Navigation Path:

Navigator → Tools → Reports and Analytics

Click:

• Browse Catalog → New → Analysis

Step 2 – Select Subject Area

Choose appropriate subject area.

Example:

• Payables Invoices – Transactions Real Time

👉 Tip: Selecting the right subject area is 50% of the work done correctly

Step 3 – Select Columns

From left panel:

Drag and drop:

• Invoice Number
• Supplier Name
• Invoice Amount
• Invoice Date

Step 4 – Apply Filters

Click on column → Filter

Example filters:

• Invoice Status = ‘Unpaid’
• Business Unit = ‘Vision Operations’

Step 5 – Add Calculated Columns (Optional)

Example:

• Aging Days = Current Date – Invoice Date

Step 6 – Add Sorting and Aggregation

• Sort by Invoice Date
• Aggregate by Supplier

Step 7 – Choose Visualization

Options:

• Table
• Pivot
• Bar Chart

Step 8 – Save Report

Click Save As:

• Folder: Custom → Financial Reports
• Name: AP Aging Report

Testing the OTBI Report

Example Test Scenario

Create a new invoice in Payables:

• Supplier: ABC Ltd
• Amount: ₹50,000
• Status: Unpaid

Expected Result

• Report should display:
  • Invoice details instantly
  • No ESS job dependency

Validation Checks

• Data accuracy
• Filters applied correctly
• Security restrictions working

Common Implementation Challenges

1. Wrong Subject Area Selection

Leads to missing data.

👉 Always validate with business users.

2. Performance Issues

Caused by:

• Too many columns
• No filters

3. Security Restrictions

Users may not see data due to role limitations.

4. Complex Calculations

OTBI has limitations in advanced calculations.

👉 Use BI Publisher if required.

Best Practices from Real Projects

1. Always Start with Business Requirement

Never jump directly into OTBI.

2. Limit Columns

Only fetch required data.

3. Use Filters Efficiently

Reduce data load.

4. Naming Convention

Example:

• OTBI_AP_Aging_Report_V1

5. Validate with Users Early

Avoid rework later.

6. Combine with BI Publisher

Use OTBI for:

• Real-time dashboards

Use BI Publisher for:

• Pixel-perfect reports

Frequently Asked Questions (FAQs)

1. What is the difference between OTBI and BI Publisher?

OTBI:

• Real-time
• Ad-hoc reports

BI Publisher:

• Scheduled reports
• Advanced layouts

2. Can OTBI handle large data volumes?

Not efficiently. Use filters or switch to BI Publisher.

3. Can we schedule OTBI reports?

No direct scheduling. Use BI Publisher for scheduling.

Summary

Creating OTBI reports in Oracle Fusion Financials is a critical skill for consultants and business users. It empowers organizations with real-time insights and reduces dependency on IT teams.

From my experience across multiple implementations, mastering OTBI:

• Improves reporting efficiency
• Enhances decision-making
• Reduces turnaround time for analytics

If you understand subject areas, filters, and business requirements, you can build highly effective reports quickly.

For deeper understanding, refer to Oracle official documentation:
https://docs.oracle.com/en/cloud/saas/index.html