Results for “constraint_threshold”

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

Overview

PSBFV_CONSTRAINT_SETS is a read-only Oracle EBS view owned by the APPS schema and classified under the PSB (Public Sector Budgeting) product. It exposes constraint set definitions—the named rules that cap or threshold budget amounts during budget preparation and validation. The view functions as a reporting and integration convenience layer by joining the PSB_ENTITY_SET constraint records to their owning budget groups, optional sets of books, and optional data extracts. The "FV" naming convention signals a formatted or filtered view intended for external consumption, and the presence of the WITH READ ONLY clause confirms that it cannot be used for DML.

Because constraint sets drive budget validation, this view is a natural entry point for reports, extracts, and interfaces that must present or export the constraint configuration. The user-level search term "constraint_set_id" is exposed here as the column CONSTRAINT_SET_ID, which corresponds to the underlying PSB_ENTITY_SET key.

Underlying Base Objects

The view text joins four base tables:

• PSB_ENTITY_SET PES — the primary source of constraint set name, description, threshold, entity set identifier, audit columns, and the budget group and set of books references; filtered with PES.ENTITY_TYPE = 'CONSTRAINT'.
• PSB_BUDGET_GROUPS BG — joined via BUDGET_GROUP_ID to establish the budget group each constraint set belongs to.
• GL_SETS_OF_BOOKS GL — outer-joined on SET_OF_BOOKS_ID(+), so constraint sets remain visible even when no set of books is assigned.
• PSB_DATA_EXTRACTS DE — outer-joined on DATA_EXTRACT_ID(+), preserving constraint sets that have no associated data extract.

The inner join to PSB_BUDGET_GROUPS means a constraint set is only returned when a matching budget group exists; the two outer joins prevent unrelated dependencies from excluding rows.

Key Columns

• CONSTRAINT_SET_NAME — the name (PES.NAME) that identifies the constraint set.
• DESCRIPTION — descriptive text for the constraint set.
• CONSTRAINT_THRESHOLD — the numeric threshold value enforced by the constraint.
• CONSTRAINT_SET_ID — the entity set identifier (PES.ENTITY_SET_ID); the key returned for the searched term. Because the view selects PES.ENTITY_SET_ID under this alias, it is the identifier used when querying constraint sets.
• _DF — a derived value-formatted tag with the literal value '_DF:PSB:PSB_ENTITY_SET:PES', used by the formatted-value or descriptive-flexfield framework to map the identifier for display.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard EBS audit columns supporting change tracking, reconciliation, and audit extracts.

Common Use Cases and Queries

The view is typically used to list constraint sets for a given budget group, to export constraint configuration for reporting or migration mapping, and to resolve the descriptive name associated with a CONSTRAINT_SET_ID. A representative query is:

SELECT CONSTRAINT_SET_NAME, DESCRIPTION, CONSTRAINT_THRESHOLD, CONSTRAINT_SET_ID FROM APPS.PSBFV_CONSTRAINT_SETS WHERE CONSTRAINT_THRESHOLD IS NOT NULL ORDER BY CONSTRAINT_SET_NAME;

To locate a specific constraint set by its identifier:

SELECT CONSTRAINT_SET_NAME, CONSTRAINT_THRESHOLD FROM APPS.PSBFV_CONSTRAINT_SETS WHERE CONSTRAINT_SET_ID = :constraint_set_id;

Users should remember that the view is read-only, that joining to set of books or data extracts is optional for constraint sets not assigned one, and that any reporting interface relying on CONSTRAINT_SET_ID should key against PSB_ENTITY_SET.ENTITY_SET_ID in the base table, since the view exposes that column under the CONSTRAINT_SET_ID alias.