Search Results xla_distribution_links_pk

Overview

The XLA_DISTRIBUTION_LINKS table is a core technical object within the Subledger Accounting (XLA) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the fundamental audit and reconciliation link between the transactional data generated by subledger applications—such as Payables, Receivables, and Assets—and the resulting journal entry lines created in Subledger Accounting. This table is critical for ensuring the integrity and traceability of the accounting process, providing a clear, auditable path from a source transaction line to its corresponding accounting entry. Its existence is a key architectural component that enables the detailed drill-down capabilities and accounting transparency central to Oracle's Subledger Accounting framework.

Key Information Stored

The table's structure is designed to uniquely identify the relationship between a specific transaction event and a specific journal line. Its primary key, XLA_DISTRIBUTION_LINKS_PK, is composed of four columns that together define this link. The APPLICATION_ID identifies the source subledger product (e.g., 200 for Payables, 222 for Assets). The EVENT_ID points to the specific accounting event within that application. The AE_HEADER_ID and AE_LINE_NUM together identify the exact journal entry line generated for that event, linking to the XLA_AE_LINES table. While the provided metadata lists these as the core columns, the table typically contains additional foreign key columns, such as SOURCE_DISTRIBUTION_ID and SOURCE_DISTRIBUTION_TYPE, which reference the original transaction distribution table (e.g., AP_INVOICE_DISTRIBUTIONS_ALL).

Common Use Cases and Queries

The primary use case is tracing accounting entries back to their source transactions for audit, reconciliation, and troubleshooting. A common query pattern involves joining this table to both transaction and accounting tables. For example, to find the journal lines created for a specific invoice distribution, one might query:

• SELECT xdl.*, xal.* FROM xla_distribution_links xdl
• JOIN xla_ae_lines xal ON xdl.ae_header_id = xal.ae_header_id AND xdl.ae_line_num = xal.ae_line_num
• WHERE xdl.source_distribution_id = :dist_id AND xdl.application_id = 200;

Conversely, to identify the source transaction for a given journal line, the join would be reversed to link to tables like AP_INVOICE_DISTRIBUTIONS_ALL. This table is also essential for custom reports that need to present combined transactional and accounting data, and for diagnosing issues where journal entries appear incorrect or missing.

Related Objects

XLA_DISTRIBUTION_LINKS is centrally connected to the key tables of the Subledger Accounting schema. It has a direct foreign key relationship to XLA_AE_LINES (via AE_HEADER_ID and AE_LINE_NUM) and to XLA_TRANSACTION_ENTITIES and XLA_EVENTS (via EVENT_ID and APPLICATION_ID). On the transaction side, it links to various source distribution tables, which are application-specific (e.g., AP_INVOICE_DISTRIBUTIONS_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL). Important views like XLA_DISTRIBUTION_LINKS_VL (the validated ledger view) are built upon this base table to provide a secure, multi-organization data access layer for reporting and inquiry forms.