Results for “ar_distribution_sets_pk”
6 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AR_DISTRIBUTION_SETS_ALL is a Receivables (AR) module table that stores reusable distribution sets. A distribution set groups together a set of distribution lines, allowing a single accounting template to be applied consistently across many transactions instead of re-entering the same multi-line accounting for each event. Within Oracle EBS 12.1.1 and 12.2.2, the table serves as the definition header that pairs with AR_DISTRIBUTION_SET_LINES_ALL, which holds the individual lines belonging to each set. As a definition-level object, it is referenced by operational transaction tables that require a pre-approved accounting distribution.
Reflecting the FK structure mined from the metadata, AR_DISTRIBUTION_SETS_ALL exhibits hub-leaning characteristics in a Data Vault model. It is the parent of multiple dependent references and is not itself dependent on a parent business entity, so it may be modeled as a hub, with the referencing transaction tables acting as links or satellites of downstream facts.
Key Information Stored
The table comprises 11 documented columns. The most significant are:
- DISTRIBUTION_SET_ID — Surrogate primary key (AR_DISTRIBUTION_SETS_PK); the unique identifier joined from all referencing tables. It is also a unique-index candidate via AR_DISTRIBUTION_SETS_U1.
- DISTRIBUTION_SET_NAME — The business-key candidate and user-facing name, enforced by AR_DISTRIBUTION_SETS_UK1; the value users select when applying a set.
- DESCRIPTION — Free-text description clarifying the purpose of the set.
- STATUS — Controls whether the set is active or inactive, governing its availability for selection.
- TOTAL_PERCENT_DISTRIBUTION — The total percentage represented by the set's lines, typically expected to equal 100 for balanced percentage-based sets.
- ORG_ID — Multi-org operating unit identifier, enabling the set to be segmented by organization.
- Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard WHO tracking for inserts and updates.
The _ALL suffix denotes the table is org-enabled, with ORG_ID filtering relevant rows by operating unit.
Common Use Cases and Queries
Distribution sets are most commonly referenced when a cash receipt, adjustment, or receivable activity must auto-populate its accounting. Reporting typically retrieves set definitions and their associated lines. A representative query pattern joins the header to its lines and filters by organization:
- List active sets for an operating unit:
SELECT distribution_set_id, distribution_set_name, description FROM ar_distribution_sets_all WHERE status = 'A' AND org_id = :org_id; - Validate balance of a set: compare TOTAL_PERCENT_DISTRIBUTION against the sum of percentages in AR_DISTRIBUTION_SET_LINES_ALL for the matching DISTRIBUTION_SET_ID.
- Audit usage: join AR_CASH_RECEIPTS_ALL, AR_ADJUSTMENTS_ALL, and AR_RECEIVABLES_TRX_ALL on DISTRIBUTION_SET_ID to identify where a given set is applied.
- Locate sets by name:
SELECT distribution_set_id FROM ar_distribution_sets_all WHERE distribution_set_name = :name;
These patterns support reporting on accounting templates and troubleshooting why a transaction posted to particular accounts.
Related Objects
The following objects reference AR_DISTRIBUTION_SETS_ALL through documented foreign keys, all joining on DISTRIBUTION_SET_ID:
- AR_DISTRIBUTION_SET_LINES_ALL — Child table holding the individual lines of each set; joined via DISTRIBUTION_SET_ID.
- AR_CASH_RECEIPTS_ALL — Cash receipts that apply a distribution set via DISTRIBUTION_SET_ID.
- AR_ADJUSTMENTS_ALL — Adjustments referencing a set through DISTRIBUTION_SET_ID.
- AR_RECEIVABLES_TRX_ALL — Receivable activities that reference a default accounting set via DEFAULT_ACCTG_DISTRIBUTION_SET.
Together with the header PK, these relationships establish AR_DISTRIBUTION_SETS_ALL as the central definition object linking accounting templates to the transactions that consume them.
-
Groups together a set of distribution lines
-
Groups together a set of distribution lines
-
eTRM - AR Tables and Views 12.2.2
Territory information
-
eTRM - AR Tables and Views 12.1.1
Territory information
-
eTRM - AR Tables and Views 12.1.1
Territory information
-
eTRM - AR Tables and Views 12.2.2
Territory information