Search Results get_kpi_name

Overview

BSC_BIS_LOCKS_PVT is the private implementation package body for the Oracle E-Business Suite Balanced Scorecard (BSC) lock management service. In Oracle EBS 12.1.1 and 12.2.2, the BSC module provides the Balanced Scorecard and Business Intelligence infrastructure used by Oracle Scorecard and Strategy Management. This package encapsulates the internal logic that supports BSC_BIS_LOCKS_PUB, the public-facing API that governs row-level and object-level locking across BSC configuration entities such as datasets, measures, dimensions, dimension levels, dimension groups, dimension sets, KPIs, and tabs. Locks prevent concurrent users from simultaneously editing the same scorecard definitions, which would otherwise produce data corruption or lost updates. Because the object type is PACKAGE BODY with an API classification of PVT, the package is not intended to be called directly by external application code; instead it exposes the documented procedures that the public package, concurrent programs, and internal BSC components invoke. The package is marked VALID in the APPS schema and is contained within the BSC_APPS dependency group.

Key Procedures and Functions

The package body documents forty-eight procedures and functions, including a PRIVATE declaration and a CONVERT_TABLE utility. Timestamp management routines include GET_TIME_STAMP_DATASET, SET_TIME_STAMP_DATASET, GET_TIME_STAMP_DATASOURCE, SET_TIME_STAMP_DATASOURCE, GET_TIME_STAMP_DIM_LEVEL, GET_TIME_STAMP_DIM_GROUP, and GET_TIME_STAMP_DIM_SET. These retrieve and persist the last-modified markers used to detect stale reads and to decide whether a lock may be granted or must be refreshed. Naming resolution functions include GET_DATASOURCE_NAME, GET_DIM_LEVEL_NAME, GET_DIM_GROUP_NAME, GET_DIM_SET_NAME, GET_KPI_NAME, and the TO conversion routine, which translate internal identifiers into displayable labels for messages and lock records.

Selection and relationship routines include GET_SELECTED_DIM_OBJS, GET_SELECTED_DIMENSIONS, GET_KPI_DIM_SETS_BY_DIM, and GET_KPI_DIM_SETS_BY_REL, which resolve which dimensions and dimension sets are associated with a KPI, and GET_IMPACTED_OBJECTS, which identifies the downstream objects affected when a locked object changes. CONVERT_TABLE supports internal collection-to-table transformations, and PLITBLM (the standard PL/SQL integer table type) is used for these collection parameters.

Tables Accessed

The package references BSC_SYS_DATASETS_B, the base table storing dataset definitions, and BSC_SYS_MEASURES, which holds measure metadata. BSC_TABS_B stores tab (page) definitions used by scorecard layouts. BSC_SYS_CALENDARS_VL, BSC_SYS_PERIODICITIES_VL, BSC_LOOKUPS, BSC_SYS_DATASETS_B, BSC_SYS_MEASURES, and BSC_TABS_B supply the descriptive attributes required by the timestamp and name-resolution logic. All access is performed through APPS synonyms. Standard Oracle Application Object Library utilities are used, including FND_API for API error handling, FND_MESSAGE and FND_MSG_PUB for message stack management, and the SYS STANDARD package. The package depends on BSC_APPS, BSC_BIS_LOCKS_PUB, and itself (recursive reference), and it is not referenced by any other database object, confirming its role as an internal helper.

Usage Notes

BSC_BIS_LOCKS_PVT is invoked indirectly whenever a user opens a scorecard component for editing in the Oracle Scorecard and Strategy Management application. The public wrapper BSC_BIS_LOCKS_PUB calls these private routines to acquire, validate, refresh, and release locks, and to resolve affected objects before changes are committed. Because the subprograms are private, customizations and extensions should call BSC_BIS_LOCKS_PUB rather than this package body to preserve upgrade safety. The package is not exposed through a concurrent program or a form directly; its behavior surfaces through the standard BSC forms and the lock-status indicators those forms display. This behavior is consistent across EBS 12.1.1 and 12.2.2.