Introduction
Oracle Fusion HCM Reports and Analytics is one of the most critical areas in any HCM implementation. In real-world projects, clients don’t just want to manage employee data—they want actionable insights, compliance reporting, and decision-making dashboards. This is where reporting tools like OTBI, BI Publisher, and HCM Extracts play a key role.
In Oracle Fusion Cloud 26A, reporting capabilities have evolved significantly with enhanced OTBI subject areas, improved BI Publisher performance, and tighter integration with Oracle Analytics Cloud (OAC). As a consultant, you will spend a significant portion of your project lifecycle building, validating, and optimizing reports.
This blog provides a practical, implementation-focused deep dive into Oracle Fusion HCM Reports and Analytics.
What is Oracle Fusion HCM Reports and Analytics?
Oracle Fusion HCM Reports and Analytics refers to a suite of tools used to extract, analyze, and present HR data from Fusion HCM.
It includes:
| Tool | Purpose |
|---|---|
| OTBI (Oracle Transactional Business Intelligence) | Real-time reporting |
| BI Publisher (BIP) | Pixel-perfect formatted reports |
| HCM Extracts | Data extraction for integrations |
| Workforce Management Analytics | Prebuilt dashboards |
| Oracle Analytics Cloud (OAC) | Advanced analytics and visualization |
Each tool serves a different purpose, and choosing the right one is a key skill for any consultant.
Key Features of HCM Reports and Analytics
1. Real-Time Reporting with OTBI
Directly queries transactional tables
No need for data replication
Ideal for HR dashboards and quick reports
2. Pixel-Perfect Reporting with BI Publisher
Used for statutory and formatted reports
Supports Excel, PDF, XML formats
3. Data Extraction with HCM Extracts
Used for payroll interfaces, third-party integrations
Highly configurable data grouping and delivery
4. Embedded Analytics
Role-based dashboards for HR, managers, executives
5. Security Integration
Uses data roles and security profiles
Ensures users only see permitted data
Real-World Business Use Cases
Use Case 1: HR Headcount Dashboard
A client wants:
Total employees by department
Gender diversity metrics
Monthly hiring trends
👉 Solution:
Use OTBI Workforce Management – Worker Real Time subject area
Create dashboard with filters for business units
Use Case 2: Payroll Register Report
A payroll team requires:
Employee salary breakdown
Deductions and net pay
Output in PDF format
👉 Solution:
Use BI Publisher
Create data model using SQL query or HCM data template
Design RTF template
Use Case 3: Third-Party Benefits Integration
Client needs to send employee benefits data to an external vendor.
👉 Solution:
Use HCM Extract
Schedule extract and deliver via FTP
Architecture / Technical Flow
Understanding architecture is important for selecting the right tool.
Reporting Flow Overview:
Fusion HCM Transactional Tables
OTBI Layer (Subject Areas)
BI Publisher Data Model
HCM Extract Engine
Output Delivery (Email / FTP / Dashboard)
Key Insight from Projects:
OTBI is non-intrusive and fast
BI Publisher is heavy but flexible
HCM Extracts are best for outbound integrations
Prerequisites
Before working with HCM Reports:
Required Roles
Human Capital Management Integration Specialist
BI Administrator Role
HR Analyst Role
Required Knowledge
Basic SQL (for BI Publisher)
Data security concepts
HCM business objects (Worker, Assignment, Payroll)
Step-by-Step Build Process
Let’s walk through 3 key tools with hands-on steps.
1. Creating an OTBI Report
Step 1 – Navigate to OTBI
Navigator → Tools → Reports and Analytics
Click:
Browse Catalog → New → Analysis
Step 2 – Select Subject Area
Example:
Workforce Management – Worker Real Time
Step 3 – Add Columns
Add fields like:
Worker Name
Department
Job
Hire Date
Step 4 – Apply Filters
Example:
Business Unit = “India BU”
Active Employees = Yes
Step 5 – Create Visualization
Table or Pivot
Add charts if needed
Step 6 – Save Report
Save under:
Shared Folders → Custom → HCM Reports
Consultant Tip:
Always validate subject area joins—incorrect joins lead to duplicate records.
2. Creating a BI Publisher Report
Step 1 – Navigate
Navigator → Tools → Reports and Analytics
Click → Create → Data Model
Step 2 – Create Data Set
Options:
SQL Query
HCM Data Template
Example SQL:
FROM per_all_people_f
Step 3 – Define Parameters
Example:
Business Unit
Payroll Period
Step 4 – Create Report Template
Upload RTF template (using MS Word)
Map fields using XML tags
Step 5 – Create Report
Link:
Data Model
Template
Step 6 – Schedule Report
Run manually or schedule
Output: PDF / Excel
Consultant Tip:
Always test with multiple parameter values to avoid runtime failures.
3. Creating an HCM Extract
Step 1 – Navigate
Navigator → My Client Groups → Data Exchange → HCM Extracts
Step 2 – Define Extract
Name: Employee_Benefits_Extract
Type: Full / Incremental
Step 3 – Define Data Groups
Example:
Root: Person
Child: Assignment
Child: Benefits
Step 4 – Define Attributes
Employee ID
Plan Name
Coverage
Step 5 – Define Delivery Option
FTP
Email
Step 6 – Run Extract
Submit process
Validate output file
Consultant Tip:
Use incremental extracts to improve performance in large organizations.
Testing the Technical Components
OTBI Testing
Run report with multiple filters
Validate counts with UI
BI Publisher Testing
Validate output format
Check missing/null values
HCM Extract Testing
Verify file structure
Validate integration file with vendor
Common Errors and Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| Duplicate records in OTBI | Incorrect joins | Use distinct or correct subject area |
| BI report not running | SQL error | Validate query |
| Extract performance issue | Large data volume | Use incremental extract |
| Missing data | Security restriction | Check data roles |
Best Practices from Real Projects
1. Choose the Right Tool
OTBI → Analytics
BI Publisher → Reports
Extract → Integration
2. Always Validate Security
Users often complain:
👉 “I don’t see data”
Cause:
Role-based security
3. Avoid Heavy BI Publisher Queries
Use indexed columns
Avoid complex joins
4. Naming Convention
Example:
OTBI: HCM_OTBI_Headcount_Report
BIP: HCM_BIP_Payroll_Report
5. Performance Optimization
Use filters early
Avoid unnecessary columns
Frequently Asked Questions (FAQ)
1. What is the difference between OTBI and BI Publisher?
OTBI is used for real-time analysis, while BI Publisher is used for formatted reports like payslips and statutory reports.
2. When should we use HCM Extract instead of BI Publisher?
Use HCM Extract when:
Data needs to be sent to external systems
Large data volumes are involved
Structured file output is required
3. Can OTBI reports be scheduled?
Yes, OTBI analyses can be scheduled through agents and delivered via email.
Summary
Oracle Fusion HCM Reports and Analytics is a powerful ecosystem that enables organizations to transform HR data into meaningful insights. As a consultant, your ability to choose the right tool—OTBI, BI Publisher, or HCM Extract—directly impacts performance, usability, and business value.
From real-time dashboards to complex payroll reports and integrations, mastering this area is essential for every Oracle HCM professional.
For deeper reference, always consult Oracle’s official documentation:
https://docs.oracle.com/en/cloud/saas/index.html