Search Results ar_distribution_set_lines_all




Overview
Explore in AI Chat

Overview

The AR_DISTRIBUTION_SET_LINES_ALL table is a core transactional table within Oracle E-Business Suite Receivables (AR). It defines the detailed accounting rules for revenue distribution. Specifically, it stores the individual line items that constitute a distribution set, which is a template used to automatically split a single transaction amount—such as an invoice line—across multiple general ledger (GL) accounts based on predefined percentages. This object is critical for ensuring accurate and automated financial postings, eliminating the need for manual journal entry splits for recurring revenue scenarios. Its role is integral to the period-end close and financial reporting processes within the GL.

Key Information Stored

The table's primary function is to link a distribution set header to specific GL accounts and their corresponding allocation percentages. Key columns include DISTRIBUTION_SET_ID, which foreign keys to AR_DISTRIBUTION_SETS_ALL to identify the parent template. The column DIST_CODE_COMBINATION_ID, which was the focus of the user's search, is fundamentally important. It holds the identifier (CODE_COMBINATION_ID) for the specific GL account (from GL_CODE_COMBINATIONS) to which a portion of the revenue is posted. Other critical columns are PERCENT, which defines the allocation share for this line, and SET_OF_BOOKS_ID, which ties the line to a specific ledger, ensuring accounting flexfield structure validity. The table has a composite primary key (AR_DISTRIBUTION_SET_LINES_PK) on DISTRIBUTION_SET_ID and DIST_CODE_COMBINATION_ID, enforcing uniqueness of an account within a set.

Common Use Cases and Queries

A primary use case is troubleshooting or auditing the accounting rules applied to transactions. For instance, when an invoice posts unexpected revenue accounts, one traces back through the distribution set assigned to the transaction line. A common query retrieves all account assignments for a specific distribution set, often joining to GL_CODE_COMBINATIONS to get the account segment values.

  • Sample Query: To list the detailed account breakdown for a distribution set, one might use: SELECT adsl.percent, gcc.segment1, gcc.segment2 FROM ar_distribution_set_lines_all adsl, gl_code_combinations gcc WHERE adsl.dist_code_combination_id = gcc.code_combination_id AND adsl.distribution_set_id = :p_set_id ORDER BY adsl.percent DESC;
  • Reporting Use Case: Generating a report of all distribution sets and their full account mappings for internal control documentation.
  • Validation: SQL used to verify that the sum of PERCENT for a given DISTRIBUTION_SET_ID equals 100% before the set is activated for use.

Related Objects

This table sits at the center of a key relationship network in Receivables accounting. Its most direct relationships, as per the provided metadata, are:

  • AR_DISTRIBUTION_SETS_ALL: The parent header table. The DISTRIBUTION_SET_ID foreign key links each line to its template definition.
  • GL_CODE_COMBINATIONS: The critical reference table for the accounting flexfield. The DIST_CODE_COMBINATION_ID foreign key ensures each line points to a valid GL account.
  • Transaction Lines (e.g., RA_CUSTOMER_TRX_LINES_ALL): While not listed in the brief metadata, this is a vital dependency. Columns like DISTRIBUTION_SET in transaction lines ultimately resolve to the accounts stored in AR_DISTRIBUTION_SET_LINES_ALL during the posting process (AutoAccounting or manual assignment).