(25B) Oracle Fusion Cloud HCM: Foundations of OTBI — Lesson 1: OTBI Catalog, Subject Areas, Grain, and Security Context

Technical Scope

• OTBI architecture and catalog
• HCM subject areas, facts, dimensions, and grain
• data roles, row security, and visibility
• business questions, measures, and source validation

Instructor Demonstration

Demonstrate OTBI architecture and catalog inside four HR questions that require correct subject-area grain and security before visualization, then capture the exact configuration, command, transaction, report, or code evidence that proves the result.

Applied Workshop

Implement a controlled workshop covering HCM subject areas, facts, dimensions, and grain and data roles, row security, and visibility, then test a failure or exception involving business questions, measures, and source validation.

1. Confirm environment, identity, data, dependencies, and expected result.
2. Complete the product-specific implementation or analysis.
3. Capture commands, configuration, output, logs, transactions, or reports.
4. Explain the operational, security, performance, or business trade-off.

Validation Standard

The OTBI Catalog, Subject Areas, Grain, and Security Context result must be reproducible, traceable to approved inputs, and consistent with the expected Oracle product behavior.

• The intended target and ownership are verified.
• The result is supported by reproducible evidence.
• Security, performance, reliability, and support impact are reviewed.
• Unexpected behavior is investigated before acceptance.

Failure Analysis

Diagnose issues in OTBI architecture and catalog, HCM subject areas, facts, dimensions, and grain, data roles, row security, and visibility, or business questions, measures, and source validation without making an unverified production change.

Learners isolate the smallest proven cause, apply a reversible correction, rerun validation, and record the preventive action.