Search Results psb_constraint_formulas

Overview

The PSB_CONSTRAINT_FORMULAS table is a core data definition table within the Oracle E-Business Suite (EBS) module Public Sector Budgeting (PSB), which is documented as obsolete. This table serves as the repository for defining constraint formulas, which are business rules or calculations used to enforce budgetary controls and validations within the PSB module. These formulas are critical for ensuring that budget entries, allocations, or adjustments comply with specific, configurable financial policies mandated for public sector entities. The table's role is to store the metadata and logic for these constraints, which the application engine would reference during budget transaction processing.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on identifying and categorizing each formula. The primary key is CONSTRAINT_FORMULA_ID, a unique identifier for each formula definition. Two significant foreign key relationships are documented, pointing to essential reference tables in the PSB module. The column CONSTRAINT_ID references the PSB_ENTITY table, linking the formula to a specific budgetary entity or constraint rule. The column BUDGET_YEAR_TYPE_ID references the PSB_BUDGET_YEAR_TYPES table, associating the formula with a specific fiscal calendar or budget year type. While the exact formula expression column is not named in the excerpt, the table's purpose indicates it would store the actual calculation logic, condition, or rule definition.

Common Use Cases and Queries

A primary use case involves the setup and administration of budgetary controls. System administrators would populate this table to define formulas that, for example, limit budget increases to a percentage of the prior year's amount or enforce caps on specific expenditure categories. For reporting and troubleshooting, common queries would join this table to its referenced entities. A sample query to list all defined constraint formulas with their associated entity and year type would be:

• SELECT cf.CONSTRAINT_FORMULA_ID, e.ENTITY_NAME, byt.YEAR_TYPE_NAME
• FROM PSB_CONSTRAINT_FORMULAS cf,
• PSB_ENTITY e,
• PSB_BUDGET_YEAR_TYPES byt
• WHERE cf.CONSTRAINT_ID = e.ENTITY_ID(+)
• AND cf.BUDGET_YEAR_TYPE_ID = byt.BUDGET_YEAR_TYPE_ID(+);

It is crucial to note the ETRM states this table is "Not implemented in this database," suggesting it may be a legacy definition or part of a specific, non-standard implementation.

Related Objects

The PSB_CONSTRAINT_FORMULAS table exists within a network of related PSB objects. As defined by its foreign keys, it has a direct dependency on the PSB_ENTITY table, which stores budgetary entities, and the PSB_BUDGET_YEAR_TYPES table, which defines fiscal calendars. This table would be referenced by application logic and potentially by transactional or journal tables that apply the constraints during budget entry. Given its nature as a definition table, it is likely referenced by PSB application program units (packages, procedures) responsible for validating budget transactions against the stored constraint formulas.