Search Results bsc_sys_bm_groups

Overview

The table BSC_SYS_BM_GROUPS is a core data object within the now-obsolete Balanced Scorecard (BSC) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to store and manage the relationship between individual benchmark metrics and the logical groups to which they are assigned. This structure enables the categorization and comparative analysis of performance benchmarks, a foundational concept for strategic performance management. It is critical to note that the official ETRM documentation explicitly states this table is "Not implemented in this database" for the documented instance, indicating it may be a legacy or reference structure not actively populated in all deployments. The table's design enforces data integrity through a composite primary key and a foreign key relationship to the master benchmark definitions table.

Key Information Stored

The table's structure is defined by two key columns that together form its composite primary key. The column BM_GROUP_ID uniquely identifies a specific benchmark group or category. The column BM_ID stores the identifier for an individual benchmark metric. Each row in this table represents the membership of a single benchmark (BM_ID) within a specific group (BM_GROUP_ID). This many-to-many relationship model allows a single benchmark to belong to multiple groups and a single group to contain multiple benchmarks, facilitating flexible performance analysis frameworks.

Common Use Cases and Queries

In a functional BSC environment, this table supports reporting and configuration activities. Administrators would use it to query which benchmarks are associated with a particular analytical group, or to list all groups containing a specific metric. A typical query would join BSC_SYS_BM_GROUPS to the benchmark master table (BSC_SYS_BENCHMARKS_B) to retrieve descriptive information. For instance, to retrieve all benchmarks within a specific group, one might use the following SQL pattern:

• SELECT bm.BM_NAME, bm.DESCRIPTION FROM BSC_SYS_BENCHMARKS_B bm, BSC_SYS_BM_GROUPS grp WHERE bm.BM_ID = grp.BM_ID AND grp.BM_GROUP_ID = :p_group_id;

Given the module's obsolete status, direct operational use is rare; however, such queries remain relevant for data migration, historical reporting, or system decommissioning projects.

Related Objects

The table maintains a direct and documented foreign key relationship, which is essential for understanding its data lineage and integrity constraints.

• BSC_SYS_BENCHMARKS_B: This is the primary related table. The column BSC_SYS_BM_GROUPS.BM_ID references the primary key of BSC_SYS_BENCHMARKS_B. This ensures that every benchmark ID stored in the groups table corresponds to a valid, defined benchmark in the system. The relationship is foundational for retrieving benchmark details (e.g., name, target values) for members of a group.

The table's own primary key, BSC_SYS_BM_GROUPS_PK, is defined on the combination of (BM_GROUP_ID, BM_ID), guaranteeing the uniqueness of each benchmark-to-group association.