Search Results ap_distribution_sets_all




Overview
Explore in AI Chat

Overview

The AP_DISTRIBUTION_SETS_ALL table is a core data definition table within the Oracle E-Business Suite Payables (AP) module. It serves as the master repository for Invoice Distribution Set definitions. A distribution set is a template that automates the allocation of invoice amounts across specific general ledger accounts, eliminating the need for manual entry of distribution lines for each invoice. This object is central to streamlining the invoice entry process, particularly for recurring expenses with consistent accounting patterns. As a multi-organization table (indicated by the "_ALL" suffix), it stores definitions that can be shared or partitioned across multiple operating units, with access controlled by the MOAC (Multi-Org Access Control) security model.

Key Information Stored

The table stores the defining attributes of each distribution set. The primary identifier is the system-generated DISTRIBUTION_SET_ID, which serves as the unique primary key for all related data. The human-readable identifier is the DISTRIBUTION_SET_NAME, which must be unique and is enforced by a separate unique key constraint. While the provided metadata does not list all columns, standard implementation columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and ORG_ID (for multi-org partitioning) are invariably present. Other typical columns include a description field and status indicators to control the set's active usability.

Common Use Cases and Queries

The primary use case is the automated creation of invoice distributions during invoice entry, either manually or via the Payables Open Interface. Administrators use this table to manage and audit available templates. Common reporting and validation queries include listing all active distribution sets for a given operating unit or identifying sets that have not been recently used. A typical SQL pattern to retrieve basic set information is:

  • SELECT distribution_set_id, distribution_set_name, description FROM ap_distribution_sets_all WHERE org_id = :p_org_id ORDER BY distribution_set_name;

Another critical operational query involves joining to the AP_DISTRIBUTION_SET_LINES_ALL table to review or validate the full accounting template, ensuring the percentage or amount allocations sum correctly before use.

Related Objects

AP_DISTRIBUTION_SETS_ALL has defined foreign key relationships with several key tables, establishing it as a referenced master. The documented relationships are:

  • AP_DISTRIBUTION_SET_LINES_ALL: Contains the individual line-level account assignments for each set. Joined on DISTRIBUTION_SET_ID.
  • AP_RECURRING_PAYMENTS_ALL: A distribution set can be assigned to a recurring payment template. Joined on DISTRIBUTION_SET_ID.
  • AP_SUPPLIER_SITES_ALL and PO_VENDOR_SITES_ALL: A default distribution set can be assigned at the supplier site level. Joined on DISTRIBUTION_SET_ID.
  • PO_VENDORS: A default distribution set can be assigned at the supplier (vendor) level. Joined on DISTRIBUTION_SET_ID.

These relationships demonstrate how a distribution set definition, once created, can be leveraged at various levels—from individual invoices to supplier master data—to enforce consistent accounting.