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
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 | 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.
Problems that run through this table