Search Results wf_role_orig_system

Overview

The PSB.PSB_BUDGET_GROUP_RESP table is a core data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Public Sector Budgeting (PSB) module. It serves as the central repository for managing security and workflow assignments related to budget groups. Its primary role is to define which EBS responsibilities have access to specific budget groups for data entry and review, and which workflow roles are designated to receive notifications for budget approval processes. This table is essential for enforcing budgetary security and automating workflow routing based on organizational hierarchy and user responsibility.

Key Information Stored

The table stores assignment records linking a budget group to either an EBS responsibility or a workflow role. The critical columns are BUDGET_GROUP_RESP_ID, which is the unique primary key for each assignment, and BUDGET_GROUP_ID, which identifies the relevant budget group. The table's function is determined by the RESPONSIBILITY_TYPE column. When this column's value is 'R', the assignment is for access control; the RESPONSIBILITY_ID column is populated with a value from FND_RESPONSIBILITY. When the value is 'N', the assignment is for workflow notification; the WF_ROLE_NAME, WF_ROLE_ORIG_SYSTEM, and WF_ROLE_ORIG_SYSTEM_ID columns are populated to identify the Oracle Workflow role. The table also includes standard "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

A primary use case is troubleshooting user access issues within the PSB module. Administrators can query this table to verify if a user's responsibility is granted access to a specific budget group. Another common scenario involves auditing workflow configurations to identify all roles designated as approvers for a given budget group. Sample queries include retrieving all responsibility-based assignments for a specific budget group or finding all budget groups accessible to a particular responsibility. The foundational query, as provided in the ETRM, is:

• SELECT BUDGET_GROUP_RESP_ID, BUDGET_GROUP_ID, RESPONSIBILITY_ID, WF_ROLE_NAME, RESPONSIBILITY_TYPE FROM PSB.PSB_BUDGET_GROUP_RESP WHERE BUDGET_GROUP_ID = :1;

For integrated reporting, this table is frequently joined to FND_RESPONSIBILITY_TL to get the responsibility name and to PSB_BUDGET_GROUPS_B for the budget group name.

Related Objects

PSB_BUDGET_GROUP_RESP has direct relationships with several key EBS objects. Its primary foreign key relationship is with the PSB_BUDGET_GROUPS_B table via the BUDGET_GROUP_ID column, which defines the master list of budget groups. For responsibility-based assignments (type 'R'), the RESPONSIBILITY_ID column references the FND_RESPONSIBILITY table. For workflow assignments (type 'N'), the WF_ROLE_NAME and related columns reference roles within the Oracle Workflow (WF) subsystem. The table is indexed for performance: PSB_BUDGET_GROUP_RESP_U1 is a unique index on BUDGET_GROUP_RESP_ID, and PSB_BUDGET_GROUP_RESP_N1 is a non-unique index on the combination of RESPONSIBILITY_ID and BUDGET_GROUP_ID, optimizing lookups for access validation.