Why subject area selection matters
OTBI has over 600 subject areas across all Fusion Cloud modules. Choosing the wrong one means either missing the data you need or joining incompatible dimensions that produce incorrect results.
Finance — key subject areas
Payables Invoices - Real Time: AP invoice headers, lines, distributions, payments, suppliers. Use for: invoice ageing, spend analysis by supplier, payment status.
Receivables Transactions - Real Time: AR invoices, credit memos, receipts, customers. Use for: DSO reporting, collection tracking, customer balance.
General Ledger - Journals Real Time: journal headers, lines, accounting periods, chart of accounts. Use for: journal entry audit, account analysis, period-end reconciliation.
Cash Management - Bank Statements Real Time: bank transactions, bank accounts, reconciliation status.
Procurement — key subject areas
Procurement - Purchase Orders Real Time: PO headers, lines, distributions, receipts, suppliers. Use for: open PO tracking, approval status, spend by category.
Procurement - Purchase Requisitions Real Time: requisition headers, lines, status. Use for: requisition pipeline, approval workflow analysis.
Sourcing - Negotiations Real Time: RFQ/RFP data, supplier responses, award decisions.
HCM — key subject areas
Human Capital Management - Workforce: employee headcount, assignments, positions, departments. Use for: headcount reports, org structure analysis.
Payroll - Payroll Run Results Real Time: payroll elements, run results by employee/period. Use for: payroll reconciliation, element analysis.
Recruiting - Requisitions: vacancy pipeline, candidate stages, time-to-fill.
SCM — key subject areas
Inventory - Inventory Balances Real Time: on-hand quantities by item, organisation, subinventory.
Order Management - Sales Orders Real Time: order headers, lines, fulfilment status.
Cross-module reporting challenge
OTBI subject areas are module-specific. You cannot natively join data from Payables subject area with HCM subject area in a single analysis. For cross-module reporting, use BIP with SQL joins, or use OAC with a semantic layer that spans multiple sources.
Finding columns in subject areas
Use the search box in the OTBI subject area browser to search for column names. If you can’t find “employee email”, search for “email” — it may be in a different folder than expected.