Search Results bsc_user_list_access




Overview
Explore in AI Chat

Overview

The BSC_USER_LIST_ACCESS table is a data object within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) module, which is documented as obsolete. This table's primary function is to store user-level permissions governing access to specific list buttons within the application's interface. It acts as a security control point, determining which responsibilities (and by extension, the users assigned to them) are authorized to interact with particular navigation or action buttons, thereby enforcing a granular security model for the Balanced Scorecard's analytical and reporting features. Its role is integral to the module's user interface security layer.

Key Information Stored

The table's structure centers on a composite primary key that defines a unique permission rule. The key columns are DIM_LEVEL_INDEX, RESPONSIBILITY_ID, and TAB_ID. The DIM_LEVEL_INDEX is a critical column, likely representing a hierarchical level or index within a Balanced Scorecard dimension (e.g., time, organization, measure), which contextualizes the permission. The RESPONSIBILITY_ID links to the standard EBS responsibilities table (FND_RESPONSIBILITY), identifying the job function or role to which the permission applies. The TAB_ID is a foreign key to BSC_TABS_B, identifying the specific tab or region within the application interface where the controlled list button resides. Together, these columns define a rule: a given responsibility has access to a specific button (on a specific tab) for a given dimensional level.

Common Use Cases and Queries

A primary use case is auditing security configurations to understand which responsibilities have access to sensitive scorecard functionality at various dimensional levels. Administrators might query this table to troubleshoot user access issues or to replicate permission sets. A typical query would join with responsibility and tab tables to produce a readable report. For example, to find all permissions related to a specific dimensional level (as indicated by the user's search for "dim_level_index"), one might use:

  • SELECT r.responsibility_name, t.tab_name, a.dim_level_index
  • FROM bsc_user_list_access a,
  • fnd_responsibility_vl r,
  • bsc_tabs_b t
  • WHERE a.responsibility_id = r.responsibility_id
  • AND a.tab_id = t.tab_id
  • AND a.dim_level_index = :p_index;

It is crucial to note the provided metadata states this table is "Not implemented in this database," indicating it may not be present or populated in all EBS instances, which would affect query results.

Related Objects

The BSC_USER_LIST_ACCESS table has documented foreign key relationships with other core Balanced Scorecard tables. Its primary relationship is with the BSC_TABS_B table, which stores definitions for the tabs or regions within the BSC user interface. The join is performed on the TAB_ID column (BSC_USER_LIST_ACCESS.TAB_ID = BSC_TABS_B.TAB_ID). While not explicitly listed in the provided metadata, the RESPONSIBILITY_ID column would logically reference the FND_RESPONSIBILITY table in the application's foundation layer. The table's primary key constraint is named BSC_USER_LIST_ACCESS_PK, enforcing uniqueness on the combination of DIM_LEVEL_INDEX, RESPONSIBILITY_ID, and TAB_ID.