Search Results disabled_calc_id

Overview

The BSC_SYS_DATASET_CALC table is a configuration and control entity within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) application. Its primary role is to manage the selective disabling of specific calculations at the dataset level. In the context of performance management and strategic planning, this table provides administrators with granular control over the calculation engine, allowing them to exclude certain predefined calculations from executing for particular datasets. This is critical for tailoring performance metrics, optimizing system performance by skipping irrelevant computations, and ensuring data integrity within complex, multi-dataset implementations across versions 12.1.1 and 12.2.2.

Key Information Stored

This table is a straightforward intersection entity consisting of two mandatory foreign key columns that form a composite primary key. Each record represents a single disabled calculation rule for a dataset.

• DATASET_ID (NUMBER): The unique identifier for a dataset, as defined in the BSC_SYS_DATASETS_B table. This column links the disabling rule to a specific data context or perspective within the Balanced Scorecard.
• DISABLED_CALC_ID (NUMBER): The unique identifier for a calculation that is to be disabled, as defined in the BSC_SYS_CALCULATIONS table. This column specifies the exact calculation process that will be suppressed for the associated dataset.

Common Use Cases and Queries

The primary use case is administrative reporting and validation of disabled calculations. System administrators or functional consultants query this table to audit which calculations are turned off for specific datasets, often during troubleshooting, performance tuning, or implementation reviews. A typical query involves joining to the referenced tables to get descriptive names.

Sample Query to List All Disabled Calculations with Descriptions:
SELECT ds.DATASET_ID,
ds.NAME DATASET_NAME,
dc.DISABLED_CALC_ID,
calc.NAME CALCULATION_NAME
FROM BSC.BSC_SYS_DATASET_CALC dc
JOIN BSC.BSC_SYS_DATASETS_B ds ON ds.DATASET_ID = dc.DATASET_ID
JOIN BSC.BSC_SYS_CALCULATIONS calc ON calc.CALC_ID = dc.DISABLED_CALC_ID
ORDER BY ds.NAME;

Use Case for Validation: Before executing a batch of calculations for a dataset, the application logic would likely check this table to filter out any disabled CALC_IDs for the given DATASET_ID, ensuring they are not processed.

Related Objects

The BSC_SYS_DATASET_CALC table is central to a small referential integrity cluster within the BSC schema, acting as a child to two key master tables.

• Primary Key: BSC_SYS_DATASET_CALC_PK on (DATASET_ID, DISABLED_CALC_ID).
• Foreign Key (References BSC_SYS_DATASETS_B): The DATASET_ID column references the BSC_SYS_DATASETS_B table. This enforces that a dataset must be defined before a calculation can be disabled for it.
• Foreign Key (References BSC_SYS_CALCULATIONS): The DISABLED_CALC_ID column references the BSC_SYS_CALCULATIONS table. This ensures only valid, predefined calculations can be subject to a disabling rule.

These relationships define it as a pure intersection table, resolving the many-to-many relationship between datasets and calculations that are to be excluded.