Search Results ar_distribution_sets_all




Overview
Explore in AI Chat

Overview

The AR_DISTRIBUTION_SETS_ALL table is a core data structure within Oracle E-Business Suite Receivables (AR) modules, including versions 12.1.1 and 12.2.2. Its primary function is to define and store master accounting distribution sets. A distribution set is a reusable template that groups a predefined set of accounting rules (distribution lines) for automatically creating General Ledger (GL) journal entries. This object is critical for ensuring consistent and automated revenue, receivable, cash, and adjustment accounting across transactions, eliminating the need for manual account entry. As an "ALL" table, it is partitioned by the operating unit, supporting the multi-org architecture of Oracle EBS.

Key Information Stored

The table stores the header-level definition of each distribution set. While the specific column list is not fully detailed in the provided metadata, the primary and unique keys reveal the most critical data elements. The DISTRIBUTION_SET_ID column is the system-generated, unique primary identifier for the set. The DISTRIBUTION_SET_NAME column holds the user-defined, unique name for the template, such as "REVENUE_US" or "FREIGHT_ADJUSTMENT." Other typical columns in this table would include descriptive fields (DESCRIPTION), status indicators (STATUS), and audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY). The ORG_ID column, inherent to all "ALL" tables, stores the operating unit identifier for data partitioning and security.

Common Use Cases and Queries

This table is central to transaction processing and accounting integrity. A primary use case is the assignment of a distribution set to a Receivables Transaction Type (via AR_RECEIVABLES_TRX_ALL.DEFAULT_ACCTG_DISTRIBUTION_SET) to automate GL account derivation for invoices. Similarly, distribution sets are assigned to cash receipts and manual adjustments to define their accounting impact. Common queries involve listing active distribution sets for a given operating unit or tracing the accounting setup for a specific transaction. For example:

  • To retrieve all distribution sets for a specific ORG_ID: SELECT distribution_set_id, distribution_set_name, description FROM ar_distribution_sets_all WHERE org_id = :p_org_id ORDER BY distribution_set_name;
  • To find which transaction types use a specific distribution set: SELECT name FROM ar_receivables_trx_all WHERE default_acctg_distribution_set = :p_dist_set_id;

Related Objects

AR_DISTRIBUTION_SETS_ALL is a parent table with several key dependencies, as indicated by the foreign key relationships. The AR_DISTRIBUTION_SET_LINES_ALL table is its direct child, storing the detailed accounting rules (percentage, account segments) that constitute the set. Major transaction tables reference it to apply these accounting rules: AR_ADJUSTMENTS_ALL for credit/debit memos, AR_CASH_RECEIPTS_ALL for receipts and applications, and AR_RECEIVABLES_TRX_ALL for invoice and commitment transactions. This network of relationships underscores its role as a central hub for standardized accounting configuration within Receivables.