Results for “ar_distribution_sets_all”
50+ 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
-
distribution set header extract
APPS.AR_DISTRIBUTION_SETS_H_V·↳ AR_DISTRIBUTION_SETS_ALL·↳ AR_XLA_LINES_EXTRACT·Explore AR module →
-
distribution set header extract
APPS.AR_DISTRIBUTION_SETS_H_V·↳ AR_DISTRIBUTION_SETS_ALL·↳ AR_XLA_LINES_EXTRACT·Explore AR module →
-
Links General Ledger to Receivables miscellaneous cash
Not implemented in this database·Explore FV module →
-
Links General Ledger to Receivables miscellaneous cash
Not implemented in this database·Explore FV module →
-
The percentage and account for each line in a distribution set
-
The percentage and account for each line in a distribution set
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
VIEW: APPS.AR_AEL_GL_REC_V 12.1.1
-
VIEW: APPS.AR_AEL_GL_REC_V 12.2.2
-
VIEW: APPS.AR_AEL_SL_REC_V 12.2.2
-
VIEW: APPS.AR_AEL_SL_REC_V 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
View: AR_AEL_SL_REC_V 12.1.1
APPS.AR_AEL_SL_REC_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_CASH_RECEIPTS_ALL·↳ AR_CASH_RECEIPT_HISTORY_ALL·Explore AR module →
-
View: AR_AEL_SL_REC_V 12.2.2
APPS.AR_AEL_SL_REC_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_CASH_RECEIPTS_ALL·↳ AR_CASH_RECEIPT_HISTORY_ALL·Explore AR module →
-
View: AR_AEL_SL_REC_MRC_V 12.1.1
APPS.AR_AEL_SL_REC_MRC_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_CASH_RECEIPTS_ALL_MRC_V·↳ AR_CASH_RECEIPT_HIST_ALL_MRC_V·Explore AR module →
-
View: AR_AEL_SL_REC_MRC_V 12.2.2
APPS.AR_AEL_SL_REC_MRC_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_CASH_RECEIPTS_ALL_MRC_V·↳ AR_CASH_RECEIPT_HIST_ALL_MRC_V·Explore AR module →
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
Accounting information for Receivables activities
-
View: AR_CASH_RECEIPTS_V 12.1.1
This is the base table view for the Receipts window.
APPS.AR_CASH_RECEIPTS_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_MISC_CASH_DIST·↳ AR_BATCHES_ALL·Explore AR module →