Search Results psb_entity

Overview

The PSB_ENTITY table is a core master data table within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It serves as the central repository for the definitions of three fundamental PSB components: parameters, constraints, and allocation rules. These components are essential for modeling complex public sector budgeting scenarios, enabling the configuration of budget calculations, spending limits, and fund distribution logic. The table's role is to store the header-level metadata and definitions for these entities, which are then referenced and detailed in numerous related transactional and setup tables throughout the PSB application.

Key Information Stored

While the provided metadata does not list specific columns, the primary key is documented as ENTITY_ID. This unique identifier is the critical column, acting as the foreign key for a wide array of related tables. Based on the table's description and its relationships, it logically stores defining attributes for each entity type. For a parameter, this likely includes its name, data type, and calculation context. For a constraint, it would define the type of limit (e.g., hard or soft) and its enforcement rules. For an allocation rule, it would specify the rule's purpose and high-level execution logic. The table essentially holds the "what" of each entity, while the "how" (formulas, percentages, assignments) is stored in child tables.

Common Use Cases and Queries

This table is primarily accessed for setup, audit, and troubleshooting purposes within the PSB module. Common operational queries involve identifying all defined budgeting entities or tracing the configuration of a specific rule. For instance, to list all parameters, constraints, and allocation rules defined in the system, a query would select from PSB_ENTITY, potentially joining descriptive flexfield columns. A more diagnostic query might join PSB_ENTITY with PSB_ENTITY_ASSIGNMENT to verify which budget organizations or ledgers a specific constraint is assigned to, using the ENTITY_ID as the link. Technical consultants often reference this table when debugging budget calculation issues to confirm the base definition of a parameter or constraint referenced in an error log.

Related Objects

As indicated by the foreign key relationships, PSB_ENTITY is a parent table to several key PSB setup tables. The most significant relationships include:

• PSB_ENTITY_ASSIGNMENT: Links entities (parameters, constraints, rules) to specific budgets or organizations.
• PSB_PARAMETER_FORMULAS and PSB_CONSTRAINT_FORMULAS: Store the detailed calculation logic for parameters and constraints, respectively, referencing back to the ENTITY_ID.
• PSB_ALLOCRULE_PERCENTS: Holds the detailed distribution percentages or amounts for an allocation rule.
• PSB_SET_RELATIONS: Demonstrates a complex relationship where this table can be referenced for a parameter_id, constraint_id, or allocation_rule_id, likely used for grouping or sequencing entities within a budget set.

This network of dependencies underscores that PSB_ENTITY is the foundational definition table for the PSB module's configurable logic.