Search Results total_percent_distribution




Overview
Explore in AI Chat

Overview

APPS.AP_DISTRIBUTION_SETS_DSN_V is a reporting and validation view in the Oracle E-Business Suite Payables (AP) module, owned by the APPS schema. It is a "DSN" (distribution set name) view whose purpose is to expose a curated subset of the distribution sets defined in Oracle Payables: specifically those that are currently active and are fully allocated, meaning their component percentages total exactly 100. Distribution sets are reusable templates that let a Payables user automatically spread an invoice or payment amount across multiple accounts, cost centers, or percentage splits without re-entering every line. Because downstream forms, concurrent programs, and integrations must only select distribution sets whose percentages balance to 100, this view provides a reliable, self-filtering source. In Oracle EBS 12.1.1 and 12.2.2 the object is defined identically; the view text is a simple projection over the base table with two predicate conditions, so it carries no version-specific logic.

Underlying Base Objects

The view is defined exclusively over the base table AP_DISTRIBUTION_SETS, accessed through its APPS synonym. No joins, lookups, or additional tables are referenced. The view text is:

The first predicate excludes any distribution set whose INACTIVE_DATE has already passed, while treating a null INACTIVE_DATE as "never expires." The second predicate restricts output to sets whose TOTAL_PERCENT_DISTRIBUTION equals 100, guaranteeing that only balanced sets are returned. The view therefore inherits the structure and data types of AP_DISTRIBUTION_SETS but renames DISTRIBUTION_SET_NAME to DISTRIBUTION for convenience.

Key Columns

  • DISTRIBUTION – The distribution set name, sourced from AP_DISTRIBUTION_SETS.DISTRIBUTION_SET_NAME. This is the user-facing identifier displayed in Payables distribution set lists and LOVs.
  • DISTRIBUTION_SET_ID – The unique internal identifier for the distribution set, sourced from AP_DISTRIBUTION_SETS.DISTRIBUTION_SET_ID. It is the primary key used to join to the underlying distribution set lines (AP_DISTRIBUTION_SET_LINES) or to reference the set in other Payables tables.
  • TOTAL_PERCENT_DISTRIBUTION – The sum of the percentages assigned to the set's component lines, sourced from AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION. Because of the view's filter, this column always returns the value 100 for any row visible through the view, making it useful mainly as a validation flag rather than a variable measure.

Common Use Cases and Queries

The view is typically used to populate selection lists and to validate that only complete distribution sets are available to users or interfaces. A common query retrieves the name and ID of all active, balanced sets, often for a lookup or for driving an integration that creates invoice distributions:

  • SELECT distribution_set_id, distribution FROM ap_distribution_sets_dsn_v ORDER BY distribution;
  • SELECT distribution_set_id FROM ap_distribution_sets_dsn_v WHERE distribution = :p_name;
  • SELECT COUNT(*) FROM ap_distribution_sets_dsn_v; — to count usable distribution sets in an environment.

Because the view already enforces the "equals 100" and "not inactive" conditions, callers do not need to repeat that logic; they can rely on the view to return only sets that can be safely applied. When the underlying AP_DISTRIBUTION_SETS row is deactivated or its percentages are edited away from 100, the set silently drops out of the view on the next query, which is the intended behavior for reporting and LOV consumption.