Search Results constraint_threshold




Overview
Explore in AI Chat

Overview

APPS.PSB_REVISION_RULE_SETS_V is a reporting and integration view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, delivered as part of the Public Sector Budgeting (PSB) module within the Enterprise Resource Planning (ERP) application suite. The view presents revision rule sets, which define how budget revisions are validated and processed across budget entities. Specifically, the view filters the underlying entity set data to expose only those records where the entity type is 'BRR', denoting Budget Revision Rules. This restriction isolates the revision rule set configuration from other entity set categories stored in the same base table, allowing reporting, concurrent programs, and integration interfaces to retrieve revision rule metadata without applying additional filtering logic.

From a reporting perspective, the view surfaces configuration data critical to understanding how budget revisions behave within an organization, including the entity set identity, descriptive attributes, constraint thresholds, budget group references, and ledger context. The inclusion of the constraint_threshold column is particularly relevant, as it governs the tolerance or limit applied when validating budget revision transactions, making the view a primary reference point for administrators and technical users investigating revision rule behavior.

Underlying Base Objects

The view is defined over a single base table, PSB_ENTITY_SET. It does not reference any additional joined objects; all exposed columns are drawn directly from that table. The defining predicate is ENTITY_TYPE = 'BRR', which constrains the result set to budget revision rule entities.

Because the view is a simple projection with a filter and no joins, its performance characteristics closely mirror those of queries against the base table. Standard columns such as ROWID are exposed, permitting row-level identification of source records. The view does not perform aggregation or transformation, so values map one-to-one to the underlying table rows matching the entity type predicate.

Key Columns

  • ENTITY_SET_ID — Primary identifier for the revision rule set within the entity set table.
  • NAME and DESCRIPTION — User-defined labels describing the revision rule set.
  • CONSTRAINT_THRESHOLD — Threshold value governing constraint enforcement during budget revision processing; central to validating revision amounts against defined limits.
  • BUDGET_GROUP_ID — Reference to the budget group to which the revision rule set applies.
  • SET_OF_BOOKS_ID — Ledger identifier establishing the accounting context for the rule set.
  • ENABLE_FLAG — Indicates whether the revision rule set is active.
  • ATTRIBUTE1 through ATTRIBUTE10 and CONTEXT — Descriptive flexfield segments supporting extensible configuration.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard audit columns tracking record creation and modification.

Common Use Cases and Queries

Typical use cases include auditing revision rule configuration, diagnosing budget revision validation errors, and extracting setup data for migration or integration. The following query lists active revision rule sets with their constraint thresholds:

  • SELECT entity_set_id, name, constraint_threshold, budget_group_id, set_of_books_id FROM apps.psb_revision_rule_sets_v WHERE enable_flag = 'Y';
  • SELECT name, constraint_threshold FROM apps.psb_revision_rule_sets_v WHERE set_of_books_id = :ledger_id ORDER BY name;

These queries support administrators seeking to verify configuration, integration developers building interfaces that consume revision rule metadata, and analysts performing impact assessments prior to modifying budget structures.