Search Results set_relation_id




Overview
Explore in AI Chat

Overview

The PSB.PSB_SET_RELATIONS table is a core data repository within Oracle E-Business Suite's Public Sector Budgeting (PSB) module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to manage the assignment of predefined account sets and position sets to various budgeting entities. This design enables the sharing and reuse of these sets across multiple components of the budgeting system. The table acts as a central junction, linking sets to the specific budget groups, parameters, constraints, allocation rules, and workflow rules where they are applied, thereby enforcing consistent financial and positional structures across the budgeting process.

Key Information Stored

The table's structure is defined by a series of foreign key columns that link to different budgeting entities, with a unique identifier for each relationship. The primary and most significant columns include:

Common Use Cases and Queries

A primary use case is auditing and reporting to understand which account or position sets are utilized across the budgeting configuration. For instance, to identify all budget groups associated with a specific account set, a query would join PSB_SET_RELATIONS to the budget group master table. Another common scenario involves troubleshooting setup issues, such as determining why a particular constraint is not applying as expected by verifying its linked set assignment. A fundamental query pattern retrieves all relationships for a given entity type, leveraging the relevant non-unique index (e.g., N1 for PARAMETER_ID).

-- Example: Find all account/position sets assigned to a specific Budget Group
SELECT sr.account_position_set_id, aps.set_name
FROM psb.psb_set_relations sr,
     psb.psb_account_position_sets aps
WHERE sr.budget_group_id = :p_budget_group_id
  AND sr.account_position_set_id = aps.account_position_set_id
  AND sr.account_position_set_id IS NOT NULL;

Related Objects

PSB_SET_RELATIONS is a central hub with dependencies to numerous master tables in the PSB schema. Key related objects include the tables referenced by its foreign key columns, such as PSB_BUDGET_GROUPS_B, PSB_PARAMETERS_B, PSB_CONSTRAINTS_B, and PSB_ALLOCATION_RULES_B. The most direct parent object is PSB_ACCOUNT_POSITION_SETS, which stores the definition of the sets being assigned. The table's integrity is enforced by its unique primary key index (PSB_SET_RELATIONS_U1 on SET_RELATION_ID) and a suite of non-unique indexes (N1 through N9) on each foreign key column to optimize query performance for lookups by any related entity.