Search Results bsc_tab_ind_groups_b_u1

Overview

The BSC_TAB_IND_GROUPS_B table is a core repository within the Oracle Balanced Scorecard (BSC) application, a strategic performance management framework in Oracle E-Business Suite (EBS). This table functions as a junction table that defines the structural layout and membership of indicator groups within the context of a specific tab and Critical Success Factor (CSF). It is essential for rendering the visual hierarchy and organization of performance indicators on scorecard tabs, linking high-level strategic objectives (CSFs) to the groups of metrics used to measure them.

Key Information Stored

The table stores metadata that governs the presentation and logical grouping of indicators. The primary key, enforced by the unique index BSC_TAB_IND_GROUPS_B_U1, is a composite of TAB_ID, CSF_ID, and IND_GROUP_ID, ensuring a unique group definition per tab and CSF combination. Key columns include TAB_ID (the identifier for the scorecard tab), CSF_ID (the identifier for the Critical Success Factor), and IND_GROUP_ID (the identifier for the indicator group itself). The table also stores extensive layout attributes such as LEFT_POSITION, TOP_POSITION, WIDTH, and HEIGHT, which control the group's placement and dimensions on the tab. The SHORT_NAME column, indexed by BSC_TAB_IND_GROUPS_B_N1, provides an abbreviated identifier for the group.

Common Use Cases and Queries

This table is central to queries that analyze or troubleshoot the structure of a Balanced Scorecard. A primary use case is retrieving the complete layout configuration for a specific tab to understand how CSFs and their indicator groups are organized. For instance, to find all groups associated with a particular CSF (as indicated by the user's search for "csf_id"), the following query is typical:

• SELECT TAB_ID, IND_GROUP_ID, SHORT_NAME, LEFT_POSITION, TOP_POSITION FROM BSC.BSC_TAB_IND_GROUPS_B WHERE CSF_ID = <specific_csf_id> ORDER BY TAB_ID, NAME_POSITION;

Another common scenario involves generating a report of all groups across tabs, which can be achieved by joining with related descriptive tables like BSC_TABS_B for tab names and BSC_CSFS_B for CSF names. Administrators may also query this table to audit or modify group positioning attributes directly in the database for advanced customizations.

Related Objects

As a foundational configuration table, BSC_TAB_IND_GROUPS_B is referenced by the APPS synonym of the same name, which is the standard access point for all application code. It has a direct relationship with the BSC_TABS_B table (via TAB_ID) and the BSC_CSFS_B table (via CSF_ID). The IND_GROUP_ID likely references a master list of indicator groups, potentially in a table such as BSC_IND_GROUPS_B. The groups defined in this table are populated with specific indicators through related junction tables, such as BSC_TAB_INDICATORS_B, completing the hierarchy from Tab -> CSF -> Indicator Group -> Individual Indicator.