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:

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.