Results for “position_set_group_id”

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

Overview

The view PSB_PAY_ELEMENT_DISTRIBUTION_V belongs to the PSB (Public Sector Budgeting) product family within Oracle E-Business Suite releases 12.1.1 and 12.2.2. Public Sector Budgeting is documented as an obsolete module in the ETRM registry, and this view is explicitly flagged as "Not implemented in this database" in the source metadata. Its intended purpose is to expose a distinct, deduplicated projection of pay element distribution configuration, returning the effective-dated association between a position set group and a distribution set. The DISTINCT keyword signals that the consuming report or integration expects a non-repetitive list of effective distribution assignments rather than the row-per-transaction detail stored in the base table.

Underlying Base Objects

The view is defined exclusively over the single base table PSB_PAY_ELEMENT_DISTRIBUTIONS. No additional joins, unions, or subqueries are documented in the associated ETRM metadata, nor are any DBA-level dependencies such as synonyms, views, or packages recorded. Consequently, the view behaves as a filtering and de-duplication layer on top of the base table, projecting four columns while collapsing duplicate combinations via SELECT DISTINCT. Removal of duplicate tuples occurs across the full selected column list, so rows are unique only on the combination of position set group, effective dates, and distribution set.

Key Columns

• POSITION_SET_GROUP_ID — Identifier of the position set group whose pay element distribution is being described. This is the principal grouping key for downstream allocation or budgeting logic.
• EFFECTIVE_START_DATE — The date from which the position set group / distribution set association becomes valid.
• EFFECTIVE_END_DATE — The date on which the association ceases to be valid, enabling effective-dated (temporal) querying.
• DISTRIBUTION_SET_ID — Identifier of the distribution set applied to the position set group. This is the column most frequently referenced when users search for "distribution_set_id," since it links pay element distribution configuration to the distribution set definitions used in costing and budgeting flows.

Because only these four columns are exposed, consumers must join back to the base table or to position set and distribution set definition views to resolve descriptive names.

Common Use Cases and Queries

Typical usage targets reporting and integration scenarios: identifying which distribution sets are assigned to a position set group for a given period, auditing effective-dating coverage, and driving allocation logic that must respect temporal validity. A representative query filtering by the user's search term would be:

SELECT position_set_group_id, effective_start_date, effective_end_date, distribution_set_id
FROM psb_pay_element_distribution_v
WHERE distribution_set_id = :distribution_set_id;

An alternative effective-dated lookup retrieves assignments active on a specified date:

SELECT position_set_group_id, distribution_set_id
FROM psb_pay_element_distribution_v
WHERE :as_of_date BETWEEN effective_start_date AND effective_end_date;

Given the obsolete status and the "not implemented" annotation, deployments on 12.1.1 or 12.2.2 should verify the view's existence in their database before referencing it; where absent, equivalent reporting must query PSB_PAY_ELEMENT_DISTRIBUTIONS directly with an explicit DISTINCT clause.