Oracle Fusion/Financials/SLA

XLA_TRANSACTION_ENTITIES

The subledger 'entity' a set of accounting events belongs to — e.g. one AP invoice or one AR receipt.

Key Columns

ENTITY_IDAPPLICATION_IDLEDGER_IDENTITY_CODESOURCE_ID_INT_1SOURCE_ID_CHAR_1

Child Tables

XLA_EVENTS

Accounting events — the business events a subledger raises for accounting (e.g. 'Invoice Validated', 'Payment Cleared').

Common Joins

XLA_EVENTSvia ENTITY_ID

The accounting events raised for this transaction.

Used In

SLA

Notes

SOURCE_ID_INT_1 usually holds the subledger transaction's primary key (e.g. INVOICE_ID). ENTITY_CODE names the transaction type.

Subledger Accounting (XLA) event model

Each subledger transaction is an entity (XLA_TRANSACTION_ENTITIES) that raises accounting events (XLA_EVENTS). Create Accounting turns events into journal headers/lines (XLA_AE_HEADERS / XLA_AE_LINES); XLA_DISTRIBUTION_LINKS ties each transaction distribution to its journal line, and GL_IMPORT_REFERENCES bridges the posted GL line back to XLA.