Oracle Fusion · Data dictionary
XLA_DISTRIBUTION_LINKS
Subledger AccountingUsed in 18 subject areas9 reporting columns
Subledger Accounting (XLA) — distribution links. Connects subledger transaction lines (AP, AR, FA, …) to their resulting XLA accounting lines. The traceability layer between source and GL.
Primary key: AE_HEADER_ID, AE_LINE_NUM
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_LINE_CODE | ● | Code identifying the accounting line. | |
| AE_HEADER_ID | PK | ○ | Identifier for the ae header. |
| AE_LINE_NUM | PK | ○ | Ae line number. |
| DOC_ROUNDING_ACCTD_AMT | ● | Doc rounding acctd amount. | |
| DOC_ROUNDING_ENTERED_AMT | ● | Doc rounding entered amount. | |
| REF_AE_LINE_NUM | ● | Reference ae line number. | |
| SOURCE_DISTRIBUTION_TYPE | ● | Type of source distribution. | |
| UNROUNDED_ACCOUNTED_CR | ● | Unrounded accounted cr. | |
| UNROUNDED_ACCOUNTED_DR | ● | Unrounded accounted dr. | |
| UNROUNDED_ENTERED_CR | ● | Unrounded entered cr. | |
| UNROUNDED_ENTERED_DR | ● | Unrounded entered dr. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
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.
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Transactions Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Payments - Disbursements Real Time
- Procurement - Spend Real Time
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Receivables - Adjustments Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Receipts Details Real Time
- Receivables - Revenue Adjustments Real Time
- Receivables - Standard Receipts Application Details Real Time
- Receivables - Transactions Real Time
- Revenue Management - Revenue Recognition Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for XLA_DISTRIBUTION_LINKS?
We ship parameterized SQL, BICC config, and dbt models you own.