Oracle Fusion · OTBI subject area
General Ledger - Balances Real Time
Free reference7 tables18 columnsFinancials
This is the OTBI subject area you select in Reports & Analytics to report on general ledger data. It exposes the presentation columns mapped to the physical tables below, and corresponds to the General Ledger module.
OTBI limit: an analysis can combine subject areas only through the dimensions they share, with a measure from each, or by stacking results with set operators such as union, and only inside one Oracle Cloud application. This one reads balances straight from the Essbase cube, not from GL_BALANCES, and every analysis needs Chart of Accounts and Period Set Name filters (Oracle's notes on this subject area). The warehouse you own joins across modules and systems on conformed keys, and reports run there, not on production.
Physical tables in this subject area
- FND_CURRENCIES_B
- FND_KF_STR_INSTANCES_VL
- GL_CALENDARS
- GL_FISCAL_DAY_V
- GL_FISCAL_PERIOD_V
- GL_LEDGERS
- GL_SEG_VAL_HIER_CF
Need to join General Ledger across other subject areas?
That's the warehouse build, conformed dimensions, reconciled to source, you own it.
Problems that run through this subject area