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.
Problems that run through this table