Oracle Fusion · Data dictionary
XLA_TRANSACTION_ENTITIES
Subledger AccountingUsed in 3 subject areas2 reporting columns
Subledger Accounting (XLA) — the entity registry. One row per source object that generates accounting (an invoice, a receipt, an asset).
Primary key: ENTITY_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ENTITY_CODE | ● | Code identifying the entity. | |
| ENTITY_ID | PK | ○ | Identifier for the entity. |
| TRANSACTION_NUMBER | ● | Transaction number. |
8 reports read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to XLA_TRANSACTION_ENTITIES.
- Cash to General Ledger Reconciliation Report
- Manual Subledger Journals Report
- AHCS Create Accounting Errors Report
- AHCS Create Accounting Report
- Global SLA Account Analysis
- AR Aging Detail Report
- Accounting Hub Journal Entry Line Extract
- Subledger Period Close Exceptions Report
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.
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for XLA_TRANSACTION_ENTITIES?
We ship parameterized SQL, BICC config, and dbt models you own.