Search Results bsc_sys_bm_groups_u1

Overview

The BSC_SYS_BM_GROUPS table is a core data structure within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) application, specifically for versions 12.1.1 and 12.2.2. As a junction or association table, its primary role is to manage the many-to-many relationship between benchmark groups and individual benchmarks. This table enables the systematic grouping of benchmarks, which are performance standards or targets, into logical collections for analysis, reporting, and strategic planning within the BSC module. Its existence is critical for organizing and relating performance metrics, allowing users to compare results against defined groups of industry or internal standards.

Key Information Stored

The table is intentionally narrow, containing only two essential columns that form a composite key. The BM_GROUP_ID column stores the unique identifier for a specific benchmark group, representing the collective entity. The BM_ID column stores the unique identifier for an individual benchmark. Each row in this table represents a single membership link, indicating that a specific benchmark (BM_ID) belongs to a specific benchmark group (BM_GROUP_ID). The uniqueness of the combination of these two columns, enforced by the BSC_SYS_BM_GROUPS_U1 index, prevents duplicate associations within the system.

Common Use Cases and Queries

The primary use case for this table is to query which benchmarks are assigned to a particular group for reporting or data validation. For instance, an administrator may need to audit all members of a specific benchmark group, or a performance report may need to aggregate data for all benchmarks within a designated group. A common query pattern retrieves all benchmark IDs for a given group. Conversely, to find all groups containing a specific benchmark, the query would filter on the BM_ID column. The fundamental query, as indicated in the ETRM, is a simple SELECT from both columns.

• Find all benchmarks in group 100: SELECT BM_ID FROM BSC.BSC_SYS_BM_GROUPS WHERE BM_GROUP_ID = 100;
• Find all groups containing benchmark 500: SELECT BM_GROUP_ID FROM BSC.BSC_SYS_BM_GROUPS WHERE BM_ID = 500;
• Full dataset extraction: SELECT BM_GROUP_ID, BM_ID FROM BSC.BSC_SYS_BM_GROUPS ORDER BY BM_GROUP_ID, BM_ID;

Related Objects

Based on the provided dependency information, the BSC_SYS_BM_GROUPS table is referenced by the APPS synonym named BSC_SYS_BM_GROUPS. This synonym allows other EBS modules and custom code within the APPS schema to access this table without prefixing the BSC schema name. The documented indexes reveal critical relationships: the unique index (BSC_SYS_BM_GROUPS_U1) suggests the BM_GROUP_ID and BM_ID columns are likely foreign keys referencing primary key columns in parent tables defining benchmark groups and benchmarks themselves (e.g., BSC_BENCHMARK_GROUPS and BSC_BENCHMARKS_B, though these specific table names are inferred from common naming conventions as they are not listed in the provided metadata). The non-unique index (BSC_SYS_BM_GROUPS_N1) on BM_ID optimizes queries that search for groups by a specific benchmark.