The Irvine Analytics enterprise data model

One model across every module. Each module's fact joins to the same conformed dimensions — Ledger, Period, Business Unit, Account, Supplier, Customer — so a journal, an invoice, a receipt, and an asset all reconcile on the same keys. This is what lets the AI Analyst answer cross-module questions, and why one number means the same thing everywhere.

Fact constellation

One conformed-dimension bus; every module's fact is a star hanging off it. This is what makes a journal, an invoice, a receipt, and an asset reconcile on the same keys — and what lets the AI Analyst answer across modules.

■ conformed dimension bus (shared keys: Ledger, Period, Business Unit, Legal Entity, Account (COA), Supplier…)■ module fact — one star schema eachClick any module to drill into its star schema, join keys, and reports.

GL-to-subledger reconciliation

How every module ties to the General Ledger: each subledger posts through Subledger Accounting (XLA) to GL journal lines and balances, which roll up to the trial balance. This is the backbone of period-close reconciliation — and why a subledger total always equals its GL control account.

Subledgers

Payables · AP_INVOICES_ALL Receivables · RA_CUSTOMER_TRX_ALL Fixed Assets · FA_DEPRN_DETAIL Cash Management · CE_STATEMENT_LINES Projects · PJC_COST_DIST_LINES_ALL Tax · ZX_LINES_V

Create Accounting →

Subledger Accounting (XLA)

Headers · XLA_AE_HEADERS Lines · XLA_AE_LINES

Every subledger posts here first — one accounting model, one audit trail.

Transfer to GL →

General Ledger

Journal lines · GL_JE_LINES

Balances · GL_BALANCES

rolls up to →

Reconciles to

Trial Balance

SLA-to-GL tie-out: every subledger total equals its GL control account.

Built to Oracle's own pattern — an immutable conformed-dimension star schema (ledger, period, business unit, account, supplier, customer, currency) for cross-subject-area analysis — and, like Oracle's Semantic Model Extensions, fully extensible: add custom dimensions, facts, and subject areas as your business needs them. The difference is ownership — this model is yours, on your cloud.

Conformed-dimension bus matrix

Which conformed dimensions each module's fact shares — the Kimball bus matrix that guarantees the modules tie together.

Module fact	Ledger	Period	Business Unit	Legal Entity	Account (COA)	Supplier	Customer	Project	Currency	Bank Account	Organization
Cash Management									●	●
Fixed Assets				●	●						●
Fusion Accounting Hub	●	●			●				●
General Ledger	●	●		●	●				●
Intercompany	●	●	●		●
Payables	●		●		●	●			●	●
Projects	●				●			●			●
Receivables	●		●		●		●		●	●
Transaction Tax	●				●

Drill deeper into this model: BICC PVO inventory by module → · OTBI subject areas & PVO matrix → · click any module above for its star schema, join keys, and reports.

Want this model built on your data?

10-day proof of concept — conformed dimensions, dbt models, reconciled to source. You own all of it.

Talk to us