Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Financials/SLA

XLA_AE_LINES

Subledger accounting event line — the account and debit/credit amount for one accounting distribution.

Key Columns

AE_HEADER_IDAE_LINE_NUMCODE_COMBINATION_IDACCOUNTED_DRACCOUNTED_CR

Parent Table

XLA_AE_HEADERS

Subledger accounting event header — the accounting entry generated from a subledger transaction, before/alongside its GL journal.

Common Joins

XLA_AE_HEADERSvia AE_HEADER_ID

The accounting entry header this line belongs to.

GL_CODE_COMBINATIONSvia CODE_COMBINATION_ID

The GL account this line's debit/credit amount posted to.

Used In

Subledger Accounting

Related

How Subledger Accounting (SLA) generates journals

Every subledger transaction (AP invoice, AR transaction, asset addition, cost transaction) that runs Create Accounting generates an XLA_AE_HEADERS/XLA_AE_LINES accounting event first — SLA's own rule-driven layer — which is then transferred to GL_JE_HEADERS/GL_JE_LINES as the actual GL journal. This is why subledger accounting rules can be customized per ledger without changing the subledger transaction tables themselves.

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.

Ask Oracle AI about XLA_AE_LINES