Search Results ar_distributions_all

Overview

The AR_DISTRIBUTIONS_ALL table is a core transactional table within Oracle E-Business Suite Receivables (AR). It serves as the central repository for all accounting entries (distributions) generated by Receivables activities. Its primary role is to store the detailed accounting records for receipts, as indicated in the ETRM description. This table is fundamental to the financial integrity of the AR module, capturing the debit and credit postings to various General Ledger accounts for transactions such as invoices, credit memos, receipts, applications, and adjustments. Being an "ALL" table, it is multi-organization enabled, storing data for all operating units accessible to the user, which is critical for installations operating in a multi-org architecture.

Key Information Stored

The table's structure is defined by its composite primary key (SOURCE_ID, SOURCE_TABLE, SOURCE_TYPE), which uniquely identifies a distribution by linking it to its originating transaction source. Key columns include LINE_ID (a unique system-generated identifier), CODE_COMBINATION_ID (the charged GL account), and AMOUNT (the monetary value of the distribution). The ETRM metadata highlights several critical foreign key relationships, such as REF_CUSTOMER_TRX_LINE_ID and REF_CUST_TRX_LINE_GL_DIST_ID linking to invoice lines, and SOURCE_ID links to numerous transaction tables like AR_CASH_RECEIPT_HISTORY_ALL and AR_ADJUSTMENTS_ALL. Columns like THIRD_PARTY_ID and THIRD_PARTY_SUB_ID facilitate accounting for third-party tax remittances.

Common Use Cases and Queries

This table is essential for auditing, reconciliation, and custom reporting on AR accounting. A common use case is tracing the complete accounting impact of a cash receipt. Analysts query this table to verify that receipt applications created the correct receivable reduction and unearned revenue or revenue accounts. Sample SQL often joins to transaction headers and GL code combinations.

• Finding distributions for a specific invoice: SELECT * FROM ar_distributions_all WHERE source_table = 'RA_CUSTOMER_TRX' AND source_id = <cust_trx_id>;
• Reconciling receipt accounting: Joining AR_DISTRIBUTIONS_ALL with AR_CASH_RECEIPTS_ALL and AR_RECEIVABLE_APPLICATIONS_ALL on SOURCE_ID to review cash, receivable, and revenue/liability account postings.
• GL Account Analysis: Summarizing amounts by CODE_COMBINATION_ID for a period to interface with or reconcile to the General Ledger.

Related Objects

As evidenced by its extensive foreign key constraints, AR_DISTRIBUTIONS_ALL has a central relationship with nearly all major Receivables transaction tables. Key related objects include:

• Transaction Sources: AR_CASH_RECEIPT_HISTORY_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_ADJUSTMENTS_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, and AR_TRANSACTION_HISTORY_ALL (linked via SOURCE_ID).
• Invoice Details: RA_CUSTOMER_TRX_LINES_ALL and RA_CUST_TRX_LINE_GL_DIST_ALL (linked via REF_CUSTOMER_TRX_LINE_ID and REF_CUST_TRX_LINE_GL_DIST_ID).
• Tax and Third-Party Data: AR_TAX_GROUP_CODES_ALL, HZ_CUST_ACCOUNTS, and HZ_CUST_SITE_USES_ALL.
• Accounting Flexfield: GL_CODE_COMBINATIONS (for the account charged).
• Self-Reference: The table has a recursive relationship with itself via REF_LINE_ID, often used for complex tax or adjustment distributions.