Analytics Catalog/Oracle Fusion ERP/General Ledger/Data model
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion ERP · GL · Data model

General Ledger data model

General Ledger modeled as 2 conformed stars — 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 reference2 stars17 PVOs

Use case. Trial balance, account analysis, and financial statements — the period balance every GL report rolls up to.

CODE_COMBINATIO…GL_CODE_COMBINATIONSaccount (chart of accounts)▪ PK CODE_COMBINATION…LEDGER_IDGL_LEDGERSledger▪ PK LEDGER_IDPERIOD_NAMEGL_PERIODSperiod▪ PK PERIOD_NAMELEGAL_ENTITY_IDXLE_ENTITY_PROFILESlegal entity▪ PK LEGAL_ENTITY_IDCURRENCY_CODEFND_CURRENCIEScurrency▪ PK CURRENCY_CODEGL_BALANCESfact · one row per account combination, …Begin Balance · Period Net · End Ba…▪ PK CODE_COMBINATION_ID
●— fact → dimension join▪ PK = primary / join key

Fact — GL_BALANCES

Grain: one row per account combination, period, and currency. Derived measures: Begin Balance, Period Net, End Balance. Drill into the fact columns:

Column inventory surfaces on the table page.

Dimensions / click any to drill into its columns

GL_CODE_COMBINATIONS → · account (chart of accounts)
ColumnDefinition
ACCOUNT_TYPEType of account.
CHART_OF_ACCOUNTS_IDIdentifier for the chart of accounts.
CODE_COMBINATION_IDIdentifier for the code combination.
ENABLED_FLAGIndicator (Y/N) for the enabled.
END_DATE_ACTIVEEnd date active.
START_DATE_ACTIVEStart date active.

all 7 columns & keys →

GL_LEDGERS → · ledger
ColumnDefinition
ACCOUNTED_PERIOD_TYPEType of accounted period.
CURRENCY_CODECode identifying the currency.
DESCRIPTIONDescription.
LEDGER_CATEGORY_CODECode identifying the ledger category.
NAMEName.
PERIOD_SET_NAMEName of the period set.

all 10 columns & keys →

GL_PERIODS · period

Column inventory surfaces on the table page.

XLE_ENTITY_PROFILES → · legal entity
ColumnDefinition
ACTIVITY_CODECode identifying the activity.
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.

all 73 columns & keys →

FND_CURRENCIES · currency

Column inventory surfaces on the table page.

Extracted by 5 BICC PVOs / same-module, fact first

These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.

full SCM & Procurement PVO → table map (General Ledger) →

Reports on this star

Use case. Journal detail, audit, and drill-through from a balance to the entries that created it.

JE_HEADER_IDGL_JE_HEADERSjournal header (batch, source…▪ PK JE_HEADER_IDCODE_COMBINATIO…GL_CODE_COMBINATIONSaccount▪ PK CODE_COMBINATION…LEDGER_IDGL_LEDGERSledger▪ PK LEDGER_IDPERIOD_NAMEGL_PERIODSperiod▪ PK PERIOD_NAMECURRENCY_CODEFND_CURRENCIESentered currency▪ PK CURRENCY_CODEGL_JE_LINESfact · one row per posted journal lineEntered Dr/Cr · Accounted Dr/Cr▪ PK JE_HEADER_ID
●— fact → dimension join▪ PK = primary / join key

Fact — GL_JE_LINES

Grain: one row per posted journal line. Derived measures: Entered Dr/Cr, Accounted Dr/Cr. Drill into the fact columns:

ColumnDefinition
ACCOUNTED_CRAccounted cr.
ACCOUNTED_DRAccounted dr.
CURRENCY_CODECode identifying the currency.
CURRENCY_CONVERSION_DATECurrency conversion date.
CURRENCY_CONVERSION_RATECurrency conversion rate.
CURRENCY_CONVERSION_TYPEType of currency conversion.
DESCRIPTIONDescription.
EFFECTIVE_DATEEffective date.

all 26 columns & keys →

Dimensions / click any to drill into its columns

GL_JE_HEADERS → · journal header (batch, source, category)
ColumnDefinition
ACCRUAL_REV_FLAGIndicator (Y/N) for the accrual rev.
ACTUAL_FLAGIndicator (Y/N) for the actual.
BALANCING_SEGMENT_VALUEBalancing segment value.
CLOSE_ACCT_SEQ_VALUEClose account seq value.
CONTROL_TOTALControl total.
CONVERSION_FLAGIndicator (Y/N) for the conversion.

all 34 columns & keys →

GL_CODE_COMBINATIONS → · account
ColumnDefinition
ACCOUNT_TYPEType of account.
CHART_OF_ACCOUNTS_IDIdentifier for the chart of accounts.
CODE_COMBINATION_IDIdentifier for the code combination.
ENABLED_FLAGIndicator (Y/N) for the enabled.
END_DATE_ACTIVEEnd date active.
START_DATE_ACTIVEStart date active.

all 7 columns & keys →

GL_LEDGERS → · ledger
ColumnDefinition
ACCOUNTED_PERIOD_TYPEType of accounted period.
CURRENCY_CODECode identifying the currency.
DESCRIPTIONDescription.
LEDGER_CATEGORY_CODECode identifying the ledger category.
NAMEName.
PERIOD_SET_NAMEName of the period set.

all 10 columns & keys →

GL_PERIODS · period

Column inventory surfaces on the table page.

FND_CURRENCIES · entered currency

Column inventory surfaces on the table page.

Extracted by 5 BICC PVOs / same-module, fact first

These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.

full SCM & Procurement PVO → table map (General Ledger) →

Reports on this star

Every BICC PVO this module exposes, mapped to the physical tables it extracts from and the star it feeds.

PVOFully-qualified nameMaps to tablesFeeds star
CodeCombinationPVOoracle.apps.financials.generalLedger.accounts.codeCombinations.publicView.analytics.CodeCombinationPVOAP_RECON_SUMMARY_CCID, AR_RECON_SUMMARY_CCID, FND_KF_STR_INSTANCES_VLBalances dim, Journals dim
FiscalDayPVOoracle.apps.financials.generalLedger.calendars.accounting.publicView.analytics.FiscalDayPVOGL_CALENDARS, GL_FISCAL_DAY_Vreference / config
FiscalPeriodPVOoracle.apps.financials.generalLedger.calendars.accounting.publicView.analytics.FiscalPeriodPVOGL_CALENDARS, GL_FISCAL_PERIOD_Vreference / config
FiscalQuarterPVOoracle.apps.financials.generalLedger.calendars.accounting.publicView.analytics.FiscalQuarterPVOGL_CALENDARS, GL_FISCAL_QUARTER_V, GL_FISCAL_YEAR_Vreference / config
FiscalYearPVOoracle.apps.financials.generalLedger.calendars.accounting.publicView.analytics.FiscalYearPVOGL_CALENDARS, GL_FISCAL_YEAR_Vreference / config
PeriodStatusPVOoracle.apps.financials.generalLedger.calendars.accounting.publicView.analytics.PeriodStatusPVOFND_APPLICATION_VL, GL_PERIOD_STATUSESreference / config
DailyRatePVOoracle.apps.financials.generalLedger.currencies.manageRate.publicView.analytics.DailyRatePVOGL_DAILY_RATESreference / config
JournalCategoryBPVOoracle.apps.financials.generalLedger.journalSetup.categories.publicView.analytics.JournalCategoryBPVOGL_JE_CATEGORIES_TLreference / config
JournalSourceBPVOoracle.apps.financials.generalLedger.journalSetup.sources.publicView.analytics.JournalSourceBPVOGL_JE_SOURCES_TLreference / config
JournalBatchPVOoracle.apps.financials.generalLedger.journals.journalEntries.publicView.analytics.JournalBatchPVOGL_JE_BATCHESreference / config
JournalHeaderPVOoracle.apps.financials.generalLedger.journals.journalEntries.publicView.analytics.JournalHeaderPVOFND_DOCUMENT_SEQUENCES, FUN_SEQ_VERSIONS, GL_ENCUMBRANCE_TYPES_VLBalances dim, Journals dim
JournalLinePVOoracle.apps.financials.generalLedger.journals.journalEntries.publicView.analytics.JournalLinePVOFND_DOCUMENT_SEQUENCES, FUN_SEQ_VERSIONS, GL_ENCUMBRANCE_TYPES_VLBalances dim, Journals fact
LedgerPVOoracle.apps.financials.generalLedger.ledgers.ledgerDefinitions.publicView.analytics.LedgerPVOFND_KF_STR_INSTANCES_VL, GL_LEDGERS, XLA_ACCTG_METHODS_TLBalances dim, Journals dim
LedgerSetPVOoracle.apps.financials.generalLedger.ledgers.ledgerSets.publicView.analytics.LedgerSetPVOGL_LEDGERS, GL_LEDGER_SET_ASSIGNMENTSBalances dim, Journals dim
LookupCodePVOoracle.apps.financials.generalLedger.shared.common.publicView.analytics.LookupCodePVOGL_LOOKUPSreference / config
GlAcctFlexBICPVOoracle.apps.financials.generalLedger.shared.flexfield.publicView.GlAcctFlexBICPVOFND_VS_TYPED_VALUES_VL, GL_SEG_VAL_HIER_CFreference / config
SegmentValueHierarchyPVOoracle.apps.financials.generalLedger.shared.flexfield.publicView.analytics.SegmentValueHierarchyPVOGL_SEG_VAL_HIER_CFreference / config
Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.
Talk to us