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

CE_STMT_BALANCES

Cash ManagementUsed in 1 subject areas2 reporting columns

Cash Management (CE) — balance table — period-end aggregates by key.

Primary key: STATEMENT_HEADER_ID, BALANCE_CODE, BALANCE_DATE_TYPE

Columns

ColumnKeyIn reportsDescription (inferred)
BALANCE_AMOUNTBalance amount.
BALANCE_CODEPKCode identifying the balance.
BALANCE_DATE_TYPEPKType of balance date.
STATEMENT_HEADER_IDPKIdentifier for the statement header.

1 report read from this table

Change a column here and these are the reports that move with it — the blast radius for any change to CE_STMT_BALANCES.

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 CE_STMT_BALANCES?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us