Search Results psb_budget_group_resp




Overview
Explore in AI Chat

Overview

The PSB_BUDGET_GROUP_RESP table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, present in both the 12.1.1 and 12.2.2 releases. It functions as a junction table that establishes the relationship between budget groups and the application responsibilities or workflow roles assigned to them. Its primary role is to enforce and manage security and workflow delegation within the budgeting process. By linking specific responsibilities to specific budget groups, this table controls which users, based on their assigned responsibility, can view, create, modify, or approve budgets for a given organizational unit or cost center defined as a budget group. This is fundamental for implementing a structured, role-based access control model in public sector budgeting environments.

Key Information Stored

The table's structure is designed to map responsibilities to budget groups. The key columns, as indicated by the provided metadata, include a primary key column and a critical foreign key. The primary key is BUDGET_GROUP_RESP_ID, a unique identifier for each responsibility-to-group assignment record. The central foreign key is BUDGET_GROUP_ID, which links directly to the PSB_BUDGET_GROUPS table. This column identifies the specific budget group to which responsibilities are being assigned. While the explicit column for the responsibility is not listed in the brief metadata, standard EBS design patterns indicate the table would also contain a column such as RESPONSIBILITY_ID (or a role identifier) to store the reference to the applicable application responsibility defined in the FND_RESPONSIBILITY table or a workflow role.

Common Use Cases and Queries

This table is central to security administration and audit reporting within PSB. A primary use case is troubleshooting user access issues; an administrator can query which responsibilities are authorized for a particular budget group. Conversely, they can identify all budget groups accessible from a given responsibility. Common SQL queries involve joining this table to PSB_BUDGET_GROUPS and FND_RESPONSIBILITY. For example, to list all responsibilities for a budget group named 'DEPARTMENT_A':

  • SELECT fr.responsibility_name, fr.application_id
  • FROM psb_budget_group_resp pbgr,
  • psb_budget_groups pbg,
  • fnd_responsibility_vl fr
  • WHERE pbgr.budget_group_id = pbg.budget_group_id
  • AND pbgr.responsibility_id = fr.responsibility_id
  • AND pbg.name = 'DEPARTMENT_A';

Another critical use case is during the setup of a new budget group, where administrators must populate this table to grant the appropriate responsibilities access to the new group.

Related Objects

PSB_BUDGET_GROUP_RESP has defined dependencies within the PSB schema, as confirmed by the metadata. Its primary relationship is with the PSB_BUDGET_GROUPS table via the foreign key on BUDGET_GROUP_ID. This is a master-detail relationship where PSB_BUDGET_GROUPS is the master table defining the budget group entity. While not explicitly listed in the snippet, the table also has a logical relationship with the core EBS security table FND_RESPONSIBILITY to resolve the responsibility ID to a named application responsibility. The table is protected by the primary key constraint PSB_BUDGET_GROUP_RESP_PK. It is a foundational object for any PSB workflows or reports that filter budget data based on responsibility-based security.