Search Results bsc_dimension_sets_pvt




Overview
Explore in AI Chat

Overview

The APPS.BSC_DIMENSION_SETS_PVT package body is a private (PVT-classified) PL/SQL API within the Oracle E-Business Suite Balanced Scorecard module. It encapsulates the core persistence and validation logic for dimension sets, dimension levels, dimension groups, and dimension level properties that underpin the Balanced Scorecard's analytical model. A dimension set defines the analytical axis structure (for example, time, organization, or product) against which Key Performance Indicators are evaluated. This package provides the internal implementation layer supporting the corresponding public API, BSC_DIMENSION_SETS_PUB, which exposes the formally supported interface to concurrent programs, forms, and external integrations. Because it is a private package, it is not intended for direct invocation by customer-written code.

Key Procedures and Functions

The package documents seventeen procedures and functions organized into logical groupings that mirror the entity hierarchy it manages:

Tables Accessed

The package operates against several Balanced Scorecard base and translation tables through APPS synonyms. BSC_KPIS_B holds the KPI definitions referenced during dimension set configuration. BSC_KPI_DIM_GROUPS stores dimension group assignments, while BSC_KPI_DIM_LEVELS_B, BSC_KPI_DIM_LEVELS_TL, and BSC_KPI_DIM_LEVELS_USER hold KPI-specific dimension level definitions, their translations, and user-defined level entries respectively. BSC_KPI_DIM_LEVEL_PROPERTIES retains property metadata for levels. BSC_KPI_DIM_SETS_TL stores the translated names and descriptions of dimension sets. The system-level definitions reside in BSC_SYS_DIM_LEVELS_B and BSC_SYS_DIM_LEVELS_TL. BSC_KPI_ANALYSIS_GROUPS and BSC_KPI_ANALYSIS_OPTIONS_B support analysis option configuration. FND_LANGUAGES is queried to validate and resolve the installed language environment during translation operations.

Usage Notes

This private package is invoked indirectly through BSC_DIMENSION_SETS_PUB and is also referenced by BSC_DIMENSION_LEVELS_PVT and one additional dependent package. Internal utilities leveraged include FND_API, FND_GLOBAL, FND_MESSAGE, and FND_MSG_PUB for the standard EBS API error-handling and message-stack conventions. The package itself is not referenced by any database object, confirming its terminal role in the dependency chain. Typical invocation flows originate from Balanced Scorecard setup forms or concurrent programs that call the public API, which subsequently delegates to this private implementation. Customizations should target the public API rather than this private package, since private APIs are subject to change between releases, including Oracle EBS 12.1.1 and 12.2.2.