Search Results bsc_user_responsibility




Overview
Explore in AI Chat

Overview

The BSC_USER_RESPONSIBILITY table is a core data object within the Oracle E-Business Suite Balanced Scorecard (BSC) application. It functions as a junction or intersection table, establishing and storing the many-to-many relationships between system users and their assigned responsibilities. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is critical for the application's security and functional access model. It determines which Balanced Scorecard responsibilities, and by extension which menus, functions, and data sets, are available to a given user upon login, thereby enforcing role-based access control within the BSC module.

Key Information Stored

The table's structure is intentionally simple, designed solely to maintain the association between a user and a responsibility. Its two primary columns form a composite primary key, ensuring a unique pairing. The USER_ID column stores a foreign key reference to a specific user record in the BSC_USERS table. The RESPONSIBILITY_ID column stores a foreign key reference to a defined responsibility in the BSC_RESPONSIBILITY table. There are no other descriptive columns; the table's sole purpose is to link these two key entities. The integrity of this data is enforced by the primary key constraint (BSC_USER_RESPONSIBILITY_PK) and the two documented foreign key constraints.

Common Use Cases and Queries

This table is central to user administration and access reporting within the Balanced Scorecard. A common operational use case is granting or revoking a user's access to a specific BSC responsibility, which involves inserting or deleting a record from this table. For reporting and troubleshooting, administrators frequently query this table to audit user access privileges. A typical query would join to the related dimension tables to retrieve meaningful names:

SELECT u.USER_NAME, r.RESPONSIBILITY_NAME
FROM BSC_USER_RESPONSIBILITY ur,
    BSC_USERS u,
    BSC_RESPONSIBILITY r
WHERE ur.USER_ID = u.USER_ID
AND ur.RESPONSIBILITY_ID = r.RESPONSIBILITY_ID
ORDER BY u.USER_NAME;

Another critical use case is during user session initialization, where the EBS framework queries this table to populate the list of available responsibilities for the authenticated user.

Related Objects

The BSC_USER_RESPONSIBILITY table has defined, documented relationships with two key parent tables in the BSC schema, forming the backbone of its data model.

  • BSC_RESPONSIBILITY: The table is linked via the foreign key on the RESPONSIBILITY_ID column. This relationship ensures that every responsibility assigned to a user is a valid, predefined responsibility.
  • BSC_USERS: The table is linked via the foreign key on the USER_ID column. This relationship ensures that every assignment is made to a valid, registered BSC user.

These relationships mean that BSC_USER_RESPONSIBILITY is a child table to both BSC_RESPONSIBILITY and BSC_USERS. Any operational or reporting logic concerning user responsibilities will necessarily involve joining through this intersection table.