Search Results psb_entity_assignment

Overview

The PSB_ENTITY_ASSIGNMENT table is a core data structure within the now-obsolete Public Sector Budgeting (PSB) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction or assignment table, establishing the many-to-many relationships between different budgeting entities and the sets to which they belong. Its primary role is to manage the assignment of various budgeting components—such as parameters, constraints, and allocation rules—to their appropriate logical groupings, known as entity sets. This assignment mechanism is fundamental for applying consistent budgeting policies and rules across defined organizational or financial dimensions within the public sector context.

Key Information Stored

The table's structure is defined by a composite primary key and its relationships to parent tables. The two key columns are:

• ENTITY_SET_ID: A foreign key column that references the PSB_ENTITY_SET table. This identifier links the assignment record to a specific logical set or grouping of budgeting rules and parameters.
• ENTITY_ID: A foreign key column that references the PSB_ENTITY table. This identifier represents the individual budgeting component (e.g., a specific parameter, constraint, or rule) being assigned to the set.

The combination of these two columns forms the primary key (PSB_ENTITY_ASSIGNMENT_PK), ensuring that a specific entity can only be assigned to a given set once, enforcing data integrity in the assignment model.

Common Use Cases and Queries

A primary use case involves querying all budgeting entities assigned to a particular set for validation, reporting, or rule execution. For instance, an administrator might need to list all constraints applicable to a specific budget cycle's parameter set. A typical query pattern would join PSB_ENTITY_ASSIGNMENT with PSB_ENTITY_SET and PSB_ENTITY to retrieve descriptive names.

SELECT esa.ENTITY_SET_ID, es.SET_NAME, esa.ENTITY_ID, e.ENTITY_NAME
FROM PSB_ENTITY_ASSIGNMENT esa,
PSB_ENTITY_SET es,
PSB_ENTITY e
WHERE esa.ENTITY_SET_ID = es.ENTITY_SET_ID
AND esa.ENTITY_ID = e.ENTITY_ID
AND es.SET_NAME = '&SET_NAME';

Conversely, to find all sets to which a specific budgeting entity is assigned, the query would filter on the ENTITY_ID. These assignments are critical for downstream budget calculation engines that must gather all relevant rules and parameters for a given budgeting scenario based on set membership.

Related Objects

PSB_ENTITY_ASSIGNMENT sits at the center of a key relationship in the obsolete PSB schema. Its existence is wholly dependent on two parent tables, as defined by its foreign key constraints:

• PSB_ENTITY_SET: The parent table for ENTITY_SET_ID. This table defines the logical sets or collections to which entities are assigned.
• PSB_ENTITY: The parent table for ENTITY_ID. This table stores the master definitions of the individual budgeting parameters, constraints, and allocation rules.

It is important to note the provided metadata explicitly states this table is "Not implemented in this database," indicating it may not be present in all EBS instances, especially those that never installed or subsequently removed the obsolete PSB module.