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
| Column | Key | In reports | Description (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.
Problems that run through this table