Search Results retrieve_dimension_levels




Overview
Explore in AI Chat

Overview

APPS.BIS_DIMENSION_LEVEL_PVT is a private PL/SQL package within the Oracle E-Business Suite Business Intelligence System (BIS) schema. Its source file, BISVDMLS.pls, is identified in the header as a "Private API for managing dimension levels for the Key Performance Framework." The package therefore forms part of the infrastructure supporting Oracle Balanced Scorecard and related Key Performance Indicator (KPI) functionality, where dimensions and their hierarchical levels must be defined, customized, translated, validated, and retrieved for use by the performance framework. As a PVT-classified package, it is not intended as a public integration surface; the header explicitly notes that maintenance should be handled by EDW once integrated with BIS. Procedures in this package support both single-record and multi-record operations against dimension level definitions and their language-specific customizations.

Key Procedures and Functions

The documented API exposes nineteen procedures and functions. The retrieval group includes RETRIEVE_DIMENSION_LEVELS (returns a collection of dimension levels for a given dimension), RETRIEVE_DIMENSION_LEVEL (returns a single dimension level record), and RETRIEVE_MULT_DIM_LEVELS (added October 2002 by arhegde, returning multiple dimension levels from an input collection). Maintenance procedures include CREATE_DIMENSION_LEVEL, UPDATE_DIMENSION_LEVEL, and DELETE_DIMENSION_LEVEL (added February 2003 by PAJOHRI).

Translation and customization are handled by TRANSLATE_DIMENSION_LEVEL, TRANS_DIMOBJ_BY_GIVEN_LANG, GET_CUSTOMIZED_NAME, GET_CUSTOMIZED_DESCRIPTION, and GET_CUSTOMIZED_ENABLED (the latter added November 2005 under Bug#4696105 as an overloaded API). Validation is performed by VALIDATE_DIMENSION_LEVEL and VALIDATE_DISABLING, which enforce business rules before records are persisted or deactivated. VALUE_ID_CONVERSION provides an identifier conversion utility used when reconciling dimension level identifiers across contexts.

Tables Accessed

The package references several BIS tables through APPS synonyms. BIS_LEVELS stores base dimension level definitions, while BIS_LEVELS_TL holds translated level attributes keyed to FND_LANGUAGES. BIS_LEVELS_S supports sequential/identifier generation. Customization data resides in BIS_LEVELS_CUSTOMIZATIONS and its translation table BIS_LEVELS_CUSTOMIZATIONS_TL, accessed by the GET_CUSTOMIZED_* and TRANSLATE_DIMENSION_LEVEL routines. BIS_TARGET_LEVELS and BIS_TARGET_VALUES support target definition and value association. BSC_KPI_DIM_LEVELS_B and BSC_SYS_DIM_LEVELS_B link KPI and system dimensions to levels. FND_LANGUAGES supplies the language list for translation, DUAL is used for singleton queries, and PLITBLM is the standard PL/SQL index-by table manipulation utility.

Usage Notes

Because BIS_DIMENSION_LEVEL_PVT is a private package, it is normally invoked indirectly—either by the public BIS_DIMENSION_LEVEL_PUB wrapper procedures, by other BIS packages (six documented callers), or by Oracle Forms and concurrent programs in the Balanced Scorecard setup flows. The translate_dimension_level routine is typically triggered when administrators enable or add a language and the existing dimension level metadata must be seeded into BIS_LEVELS_CUSTOMIZATIONS_TL and related translation tables. Custom code should prefer the public BIS APIs; direct calls to this package risk compatibility issues because parameters and behavior are not versioned for external consumption. The package behavior is consistent across EBS 12.1.1 and 12.2.2, where the BIS schema retains the same private API structure.