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
Joins (inferred from key columns): STATEMENT_HEADER_ID → CE_STATEMENT_HEADERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BALANCE_AMOUNT | ● | Balance amount. | |
| BALANCE_CODE | PK | ● | Code identifying the balance. |
| BALANCE_DATE_TYPE | PK | ○ | Type of balance date. |
| STATEMENT_HEADER_ID | PK | ○ | Identifier 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.
Problems that run through this table