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: none. Oracle's Tables and Views page declares no primary key for this table, and AE_HEADER_ID, AE_LINE_NUM is a non-unique index, so the same journal line can sit on more than one row.
Joins (inferred from key columns): AE_HEADER_ID → XLA_AE_HEADERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_LINE_CODE | ● | Code identifying the accounting line. | |
| AE_HEADER_ID | ○ | Identifier for the ae header. | |
| AE_LINE_NUM | ○ | 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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed 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.
Problems that run through this table