Results for “ap_distribution_sets_all”

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

Overview

AP_DISTRIBUTION_SETS_ALL is the Payables (AP) master table that stores Invoice Distribution Set definitions in Oracle E-Business Suite 12.1.1 and 12.2.2. A distribution set is a reusable template of accounting distributions — combinations of charge accounts, percentage allocations, and related instructions — that can be applied automatically to invoice lines, recurring payments, and supplier records, eliminating repetitive manual entry of multi-line distribution data.

The table is owned by the AP schema and is classified as VALID in the ETRM repository. Heuristically, and based on its foreign key topology, the object is best modeled as a Data Vault hub: it holds a single business concept keyed by DISTRIBUTION_SET_ID, and is referenced by several dependent and consuming tables rather than being a transactional link or descriptive satellite itself. The "_ALL" suffix reflects the presence of ORG_ID, indicating the table is partitioned by operating unit under Multi-Org Access Control (MOAC), so rows are visible per organization.

Key Information Stored

The table contains 27 documented columns. The most significant are:

• DISTRIBUTION_SET_ID — surrogate primary key (AP_DISTRIBUTION_SETS_PK) and the value propagated to all dependent tables.
• DISTRIBUTION_SET_NAME — the user-visible name of the set; part of the unique business key.
• ORG_ID — operating unit identifier; combined with DISTRIBUTION_SET_NAME it forms unique index AP_DISTRIBUTION_SETS_U2, confirming the business key is name-plus-org.
• TOTAL_PERCENT_DISTRIBUTION — the aggregate percentage the set's lines must resolve to, governing allocation validity.
• DESCRIPTION — free-text purpose or notes for the set.
• INACTIVE_DATE — date on which the set becomes unavailable for selection.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the DFF/descriptive flexfield segment set for extensibility.

Note the distinction between the surrogate primary key (DISTRIBUTION_SET_ID, also mirrored in unique index AP_DISTRIBUTION_SETS_U1) and the composite business-key candidate AP_DISTRIBUTION_SETS_U2 (DISTRIBUTION_SET_NAME, ORG_ID). The individual distribution lines that make up a set are not held here; they live in AP_DISTRIBUTION_SET_LINES_ALL.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing available sets for a given operating unit, finding sets nearing inactivation, and joining header to line data to validate allocation percentages.

• Active sets by operating unit: SELECT DISTRIBUTION_SET_ID, DISTRIBUTION_SET_NAME FROM AP_DISTRIBUTION_SETS_ALL WHERE ORG_ID = :p_org_id AND (INACTIVE_DATE IS NULL OR INACTIVE_DATE > SYSDATE).
• Header-to-line join for validation: join AP_DISTRIBUTION_SETS_ALL to AP_DISTRIBUTION_SET_LINES_ALL on DISTRIBUTION_SET_ID and compare SUM(PERCENTAGE) with TOTAL_PERCENT_DISTRIBUTION.
• Supplier assignment audit: join to AP_SUPPLIER_SITES_ALL and PO_VENDOR_SITES_ALL on DISTRIBUTION_SET_ID to trace which suppliers default to a given set.
• Recurring payment review: join to AP_RECURRING_PAYMENTS_ALL to identify templates tied to scheduled payments.

Standard Payables setup forms (Distribution Sets) and the Payables Open Interface use this table to resolve default distributions during invoice import and entry.

Related Objects

The following objects reference AP_DISTRIBUTION_SETS_ALL via the documented foreign keys, using DISTRIBUTION_SET_ID as the join column:

• AP_DISTRIBUTION_SET_LINES_ALL — the line details (accounts and percentages) belonging to each set; the primary child of this hub.
• AP_RECURRING_PAYMENTS_ALL — recurring payment templates that reference a default distribution set.
• AP_SUPPLIER_SITES_ALL — supplier site defaults pointing at a distribution set.
• PO_VENDOR_SITES_ALL — purchasing supplier site defaults pointing at a distribution set.
• PO_VENDORS — supplier-level default distribution set reference.

Because the table is the parent in all documented relationships, deletions and merges must respect these dependencies; the Payables Distribution Sets concurrent program and the invoice-distribution defaults logic both consume this structure.