Analytics Catalog/Data dictionary/XLA_AC_BALANCES
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

XLA_AC_BALANCES

Subledger AccountingUsed in 1 subject areas38 reporting columns

Subledger Accounting (XLA), balance table, period-end aggregates by key.

Primary key: not yet catalogued for XLA_AC_BALANCES, reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
BEGINNING_BALANCE_CR●Beginning balance cr.
BEGINNING_BALANCE_DR●Beginning balance dr.
ENTERED_CUR_BEGIN_BAL_CR●Entered cur begin balance cr.
ENTERED_CUR_BEGIN_BAL_DR●Entered cur begin balance dr.
PERIOD_BALANCE_CR●Period balance cr.
PERIOD_BALANCE_DR●Period balance dr.
PERIOD_ENTERED_BALANCE_CR●Period entered balance cr.
PERIOD_ENTERED_BALANCE_DR●Period entered balance dr.
SR1●Sr1.
SR10●Sr10.
SR11●Sr11.
SR12●Sr12.
SR13●Sr13.
SR14●Sr14.
SR15●Sr15.
SR16●Sr16.
SR17●Sr17.
SR18●Sr18.
SR19●Sr19.
SR2●Sr2.
SR20●Sr20.
SR21●Sr21.
SR22●Sr22.
SR23●Sr23.
SR24●Sr24.
SR25●Sr25.
SR26●Sr26.
SR27●Sr27.
SR28●Sr28.
SR29●Sr29.
SR3●Sr3.
SR30●Sr30.
SR4●Sr4.
SR5●Sr5.
SR6●Sr6.
SR7●Sr7.
SR8●Sr8.
SR9●Sr9.

Used by reports

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.

Need the extract + dbt staging for XLA_AC_BALANCES?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern