Oracle Fusion ERP · FAH · Data model
Fusion Accounting Hub data model
Fusion Accounting Hub modeled as 1 conformed star — each a fact at its own grain sharing the same dimensions. Open a star to drill into its fact and dimension columns; the last tab lists every bicc View Object the module exposes.
Free reference1 star8 PVOs
Use case. Subledger journal detail and the period-close exceptions across all subledgers.
●— fact → dimension join▪ PK = primary / join key
Fact — XLA_AE_LINES
Grain: one row per subledger accounting line. Derived measures: Entered Dr/Cr, Accounted Dr/Cr. Drill into the fact columns:
| Column | Definition |
|---|---|
| ACCOUNTED_CR | Accounted cr. |
| ACCOUNTED_DR | Accounted dr. |
| ACCOUNTING_CLASS_CODE | Code identifying the accounting class. |
| ACCOUNTING_DATE | Accounting date. |
| BUSINESS_CLASS_CODE | Code identifying the business class. |
| CURRENCY_CONVERSION_DATE | Currency conversion date. |
| CURRENCY_CONVERSION_RATE | Currency conversion rate. |
| CURRENCY_CONVERSION_TYPE | Type of currency conversion. |
Dimensions / click any to drill into its columns
XLA_AE_HEADERS → · accounting header / event
| Column | Definition |
|---|---|
| ACCOUNTING_ENTRY_STATUS_CODE | Code identifying the accounting entry status. |
| ACCOUNTING_ENTRY_TYPE_CODE | Code identifying the accounting entry type. |
| BALANCE_TYPE_CODE | Code identifying the balance type. |
| CLOSE_ACCT_SEQ_VALUE | Close account seq value. |
| COMPLETED_DATE | Completed date. |
| COMPLETION_ACCT_SEQ_VALUE | Completion account seq value. |
XLA_TRANSACTION_ENTITIES → · source transaction
| Column | Definition |
|---|---|
| ENTITY_CODE | Code identifying the entity. |
| TRANSACTION_NUMBER | Transaction number. |
GL_CODE_COMBINATIONS → · account
| Column | Definition |
|---|---|
| ACCOUNT_TYPE | Type of account. |
| CHART_OF_ACCOUNTS_ID | Identifier for the chart of accounts. |
| CODE_COMBINATION_ID | Identifier for the code combination. |
| ENABLED_FLAG | Indicator (Y/N) for the enabled. |
| END_DATE_ACTIVE | End date active. |
| START_DATE_ACTIVE | Start date active. |
GL_LEDGERS → · ledger
| Column | Definition |
|---|---|
| ACCOUNTED_PERIOD_TYPE | Type of accounted period. |
| CURRENCY_CODE | Code identifying the currency. |
| DESCRIPTION | Description. |
| LEDGER_CATEGORY_CODE | Code identifying the ledger category. |
| NAME | Name. |
| PERIOD_SET_NAME | Name of the period set. |
GL_PERIODS · period
Column inventory surfaces on the table page.
FND_CURRENCIES · entered currency
Column inventory surfaces on the table page.
Extracted by 2 BICC PVOs / same-module, fact first
These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.
- JournalEntryLinePVO → feeds the fact
- SubledgerJournalDistributionPVO → feeds the fact
full HCM PVO → table map (Fusion Accounting Hub) →
Reports on this star
Every BICC PVO this module exposes, mapped to the physical tables it extracts from and the star it feeds.
| PVO | Fully-qualified name | Maps to tables | Feeds star |
|---|---|---|---|
| BoxLabelLookupPVO | HcmTopModelAnalyticsGlobalAM.HcmTalentCalibMeetingsAM.BoxLabelLookupPVO | HRR_DASHBOARD_TMPLS_B, HRR_MEETINGS, HRR_TMPL_ANALYTIC_TYPES_B | reference / config |
| NBoxLabelPVO | HcmTopModelAnalyticsGlobalAM.HcmTalentCalibMeetingsAM.NBoxLabelPVO | HRR_DASHBOARD_TMPLS_B, HRR_MEETINGS, HRR_TMPL_ANALYTIC_TYPES_B | reference / config |
| TalentScoreBoxLabelLookupPVO | HcmTopModelAnalyticsGlobalAM.HcmTalentCalibMeetingsAM.TalentScoreBoxLabelLookupPVO | HRR_DASHBOARD_TMPLS_B, HRR_MEETINGS, HRR_TMPL_ANALYTIC_TYPES_B | reference / config |
| EventTypePVO | oracle.apps.financials.subledgerAccounting.accountingMethodSetup.eventModels.publicView.analytics.EventTypePVO | XLA_EVENT_CLASSES_TL, XLA_EVENT_TYPES_B, XLA_EVENT_TYPES_TL | reference / config |
| SupportingReferenceBalancePVO | oracle.apps.financials.subledgerAccounting.balanceInquiries.supportingReferenceBalances.publicView.analytics.SupportingReferenceBalancePVO | XLA_AC_BALANCES | reference / config |
| JournalEntryLinePVO | oracle.apps.financials.subledgerAccounting.journals.enterJournals.publicView.analytics.JournalEntryLinePVO | FND_DOCUMENT_SEQUENCES, FND_DOC_SEQUENCE_CATEGORIES, FUN_SEQ_VERSIONS | Subledger Journal Lines fact |
| SubledgerJournalDistributionPVO | oracle.apps.financials.subledgerAccounting.journals.enterJournals.publicView.analytics.SubledgerJournalDistributionPVO | FND_DOCUMENT_SEQUENCES, FND_DOC_SEQUENCE_CATEGORIES, FUN_SEQ_VERSIONS | Subledger Journal Lines fact |
| LookupPVO | oracle.apps.financials.subledgerAccounting.shared.publicView.analytics.LookupPVO | XLA_LOOKUPS | reference / config |
Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.