OracleOps AI
← Answer Library

How do I join an AR invoice to Subledger Accounting?

Join AR Invoice to Subledger Accounting (SLA)

Oracle Fusion · Financials · AR

Table RelationshipHigh confidence

Connects an AR transaction (RA_CUSTOMER_TRX_ALL) through the accounting event tables (XLA_EVENTS) to the Subledger Accounting entry (XLA_AE_HEADERS, XLA_AE_LINES).

Grounded in: Curated Oracle knowledge layer — AR, SLA

Key Tables

RA_CUSTOMER_TRX_ALL

AR transaction header representing the invoice, credit memo, or debit memo.

Common Joins

XLA_EVENTS via SOURCE_ID_INT_1 = CUSTOMER_TRX_ID

The accounting event Subledger Accounting raised for this transaction — the first hop from the AR transaction into the SLA accounting chain.

AROrder-to-CashSubledger Accounting

XLA_EVENTS

Accounting event generated by a subledger transaction, before the accounting entry itself is created.

Common Joins

RA_CUSTOMER_TRX_ALL via SOURCE_ID_INT_1

The AR transaction that raised this accounting event — one row per invoice/credit/debit memo.

XLA_AE_HEADERS via EVENT_ID

The accounting entry header actually generated from this event once Create Accounting runs.

Subledger Accounting

XLA_AE_HEADERS

Subledger accounting entry header grouping the accounting lines for an event.

Common Joins

XLA_EVENTS via EVENT_ID

The accounting event this entry was generated from.

XLA_AE_LINES via AE_HEADER_ID

The individual debit/credit lines that make up this accounting entry.

Subledger Accounting

XLA_AE_LINES

Subledger accounting entry lines — the debit/credit detail.

Common Joins

XLA_AE_HEADERS via AE_HEADER_ID

The accounting entry header this line belongs to.

GL_CODE_COMBINATIONS via CODE_COMBINATION_ID

The GL account (segment combination) this debit/credit line posted to.

Subledger Accounting

Technical Flow

RA_CUSTOMER_TRX_ALL
XLA_EVENTS
XLA_AE_HEADERS
XLA_AE_LINES

Relationships

RA_CUSTOMER_TRX_ALL (AR Invoice)
  └── XLA_EVENTS (SOURCE_ID_INT_1 = CUSTOMER_TRX_ID, APPLICATION_ID = 222)
        └── XLA_AE_HEADERS (EVENT_ID)
              └── XLA_AE_LINES (AE_HEADER_ID)

Notes

APPLICATION_ID 222 identifies Oracle Receivables in XLA_EVENTS/XLA_AE_HEADERS. XLA_ is Oracle's shared Subledger Accounting engine, used by AP, AR, Fixed Assets and Cost Management alike — this same pattern applies across subledgers, only the application ID changes.

Related Questions

Have a follow-up, or a different question?

Continue in Ask Oracle AI