Search Results bsc_bis_locks_pub




Overview
Explore in AI Chat

Overview

BSC_BIS_LOCKS_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle Business Intelligence System (BIS) / Balanced Scorecard (BSC) product family, which underpins the Oracle EBS Daily Business Intelligence and Strategic Enterprise Management modules. Functionally, the package manages locking and concurrency semantics for BIS/BSC data structures — most notably datasets, measures, dimensions, dimension sets, dimension groups, and KPI series. The "PVT" suffix denotes that this is a private implementation package: it does not constitute a published API surface and is not intended for direct invocation by customers. Instead, it is exposed only through the companion public package BSC_BIS_LOCKS_PUB, which references BSC_BIS_LOCKS_PVT and delegates the substantive work to it.

The package's responsibility is to serialize access to shared analytical metadata so that concurrent administrative operations — dataset refreshes, dimension-set edits, KPI definition changes — do not corrupt each other's state. It also tracks timestamps on datasets and datasources, and computes the set of impacted objects for a given metadata change. Because it sits under the public BIS layers, its behavior is stable and version-anchored across both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package header exposes 48 documented procedures and functions. Timestamp management is handled by GET_TIME_STAMP_DATASET, GET_TIME_STAMP_DATASOURCE, SET_TIME_STAMP_DATASET, and SET_TIME_STAMP_DATASOURCE, which read and write last-modified markers used to detect stale data. Related accessors include GET_TIME_STAMP_DIM_LEVEL, GET_TIME_STAMP_DIM_GROUP, and GET_TIME_STAMP_DIM_SET, extending timestamp tracking to dimensional metadata.

Name-resolution utilities retrieve display or internal names for metadata objects: GET_DATASOURCE_NAME, GET_DIM_LEVEL_NAME, GET_DIM_GROUP_NAME, GET_DIM_SET_NAME, and GET_KPI_NAME. Membership and dependency resolution is performed by GET_SELECTED_DIM_OBJS, GET_SELECTED_DIMENSIONS, GET_KPI_DIM_SETS_BY_DIM, and GET_KPI_DIM_SETS_BY_REL. Change-impact analysis is provided by GET_IMPACTED_OBJECTS, which enumerates dependent objects requiring revalidation after an edit. Utility routines CONVERT_TABLE, TO, and PRIVATE perform internal conversion and guarding operations. The listing itself is the authoritative enumeration; parameter signatures are not published.

Tables Accessed

The package operates against the BIS metadata tables BSC_SYS_DATASETS_B, BSC_SYS_MEASURES, and BSC_TABS_B, referenced through APPS synonyms. BSC_SYS_DATASETS_B stores dataset definitions and is central to the timestamp and lock routines. BSC_SYS_MEASURES holds measure definitions consumed during impact analysis. BSC_TABS_B defines tabular UI groupings used when resolving dimension and KPI navigation. The PL/SQL table type PLITBLM is used as an in-memory collection for passing and manipulating lists of object identifiers or names between routines.

Usage Notes

BSC_BIS_LOCKS_PVT is invoked indirectly. Application forms and administrative UI flows within DBI/SEM call the public wrapper BSC_BIS_LOCKS_PUB, which in turn calls this private package. Documented inbound references confirm calls from BSC_BIS_LOCKS_PUB, from itself, from BSC_KPI_SERIES_PUB, and from BSC_PMF_UI_WRAPPER, indicating use in KPI series management and performance-management framework UI operations. Concurrent programs that refresh BIS metadata or rebuild KPI aggregates may reach it through the same public layer. Because the package is classified PVT and is not a supported public API, customizations should never call it directly; integrators must use BSC_BIS_LOCKS_PUB or standard Oracle-supplied interfaces. Direct dependencies on internal routines risk breakage during patching.