Results for “dist_code_combination_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_DISTRIBUTION_SET_LINES_ALL is a Receivables (AR) transactional configuration table that stores the percentage and accounting account for each line of an Oracle EBS distribution set. A distribution set is a reusable template that automates revenue, tax, freight, and receivable account assignment during AutoAccounting and receipt application processing. Each row in this table represents one line of a distribution set, combining a general ledger account (via DIST_CODE_COMBINATION_ID) with a distribution percentage that governs how transaction or receipt amounts are split across accounts.

Under the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas, the table resides in the AR schema and contains 11 documented columns. The Data Vault classification heuristic mined from the foreign key structure identifies this object as a link entity. Modeled as a link, it resolves the many-to-many association between a distribution set header (AR_DISTRIBUTION_SETS_ALL) and a General Ledger code combination (GL_CODE_COMBINATIONS), while carrying descriptive satellite attributes such as PERCENT_DISTRIBUTION, DESCRIPTION, and audit columns. This classification is offered as a modeling suggestion; the operational reality is a child table of the distribution set header.

Key Information Stored

• DISTRIBUTION_SET_ID — Identifier of the parent distribution set. Together with DIST_CODE_COMBINATION_ID this forms the composite primary key (AR_DISTRIBUTION_SET_LINES_PK) and the unique business key candidate (AR_DISTRIBUTION_SET_LINES_UK1 / U1).
• DIST_CODE_COMBINATION_ID — Surrogate reference to the General Ledger account combination (GL_CODE_COMBINATIONS) to which the distribution percentage applies. This is the column most frequently searched by users and is the primary business-meaningful key of the line.
• SET_OF_BOOKS_ID — The ledger (set of books) context under which the distribution set line is defined, ensuring accounts are valid for the appropriate accounting books.
• PERCENT_DISTRIBUTION — The percentage of the transaction or receipt amount allocated to the referenced account combination. The sum of percentages across lines of a set typically equals 100.
• DESCRIPTION — Free-text description of the distribution line.
• ORG_ID — Operating unit identifier supporting multi-org (Multiple Organization) partitioning.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture WHO-column audit information for the row.

Because the primary key is composite (DISTRIBUTION_SET_ID, DIST_CODE_COMBINATION_ID), a given account combination can appear only once per distribution set. There is no separate single-column surrogate key; the surrogate identity is carried by the natural pairing of set and account combination.

Common Use Cases and Queries

The most common requirement is to join distribution set lines back to their GL accounts to report or validate account assignments. A typical query resolves the account combination using the flexfield APIs, for example:

SELECT adsl.distribution_set_id,
       adsl.dist_code_combination_id,
       adsl.percent_distribution,
       adsl.set_of_books_id
FROM   ar.ar_distribution_set_lines_all adsl
WHERE  adsl.distribution_set_id = :p_set_id;

To present the account in human-readable form, join to GL_CODE_COMBINATIONS and format the CCID with FND_FLEX_EXT.GET_COMBINATION or the standard flexfield view. Reporting scenarios include auditing that percentages total 100 per set, identifying all sets using a particular account, and reconciling AutoAccounting defaults. A common search pattern filters directly on DIST_CODE_COMBINATION_ID to find every distribution set referencing a specific account:

SELECT distribution_set_id, percent_distribution
FROM   ar.ar_distribution_set_lines_all
WHERE  dist_code_combination_id = :p_ccid;

Migration and data-conversion scripts frequently target this table when replicating distribution sets between environments, and reconciliation reports compare PERCENT_DISTRIBUTION values against the header to detect configuration drift.

Related Objects

• AR_DISTRIBUTION_SETS_ALL — Parent header table; joined on DISTRIBUTION_SET_ID. Defines the set name, type, and usage rules.
• GL_CODE_COMBINATIONS — Foreign key target of DIST_CODE_COMBINATION_ID; supplies the accounting flexfield combination referenced by each line.
• GL_LEDGERS / FND_SET_OF_BOOKS — Resolves SET_OF_BOOKS_ID to the ledger definition.
• AR_RECEIVABLES_TRX_ALL — Receivables activities that reference distribution sets for receipt and transaction accounting defaults.
• AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY_ALL — Receipt processing driven by distribution sets to determine account allocations.
• AR_AUTOACCOUNTING_RULES / AutoAccounting setup — Configuration layer that consumes distribution sets for default account derivation.

The FK relationships documented in ETRM confirm AR_DISTRIBUTION_SET_LINES_ALL as a link between the distribution set header and GL_CODE_COMBINATIONS, making it a critical junction for Receivables account assignment configuration.