Search Results bsc_bis_dim_obj_pub




Overview
Explore in AI Chat

Overview

APPS.BSC_DIMENSION_LEVELS_PUB is the public (PUB) specification of the Oracle Balanced Scorecard dimension-level maintenance API. It provides the supported programmatic interface for creating, retrieving, updating, and deleting dimension levels and their associated metadata within the Oracle E-Business Suite environment. A dimension level represents a hierarchical element of a Balanced Scorecard dimension, such as a component level within an organizational or analytical hierarchy, and carries descriptive attributes including display names, long names, help text, language, abbreviations, and column mappings.

First created in October 2001, the package has been maintained through numerous enhancement and bug-fix cycles documented in its header history, covering areas such as granular locking, WHO column maintenance, translation support, record-type length expansion, and autogenerated dimension object support. The header comment states plainly that the package "creates a BSC Dimension (Level)," confirming its role as the constructive entry point for dimension-level definition.

Key Procedures and Functions

The documented API surface comprises 26 procedures and functions. The core CRUD operations are exposed through CREATE_DIM_LEVEL, RETRIEVE_DIM_LEVEL, UPDATE_DIM_LEVEL, and DELETE_DIM_LEVEL, which manage the primary dimension-level entity and its translated attributes.

The Bsc_Dim_Level_Rec_Type record type defines the attribute payload, including Bsc_Dim_Comp_Disp_Name, Bsc_Dim_Level_Long_Name, Bsc_Dim_Level_Help, Bsc_Dim_Tot_Disp_Name, Bsc_Language, and Bsc_Level_Abbreviation. A Translate_dimension_level procedure was added to support multilingual level definitions.

Tables Accessed

The package operates against two documented base tables accessed through APPS synonyms. BSC_SYS_DIM_LEVELS_B stores the base (non-translated) definition rows for system dimension levels, and BSC_SYS_DIM_LEVELS_TL stores the translated name and help text, referenced in the record type through BSC_SYS_DIM_LEVELS_TL.NAME and BSC_SYS_DIM_LEVELS_TL.HELP. The TL table is written by create, update, and translation operations, and read by retrieval calls.

Usage Notes

As a PUB-classified package, BSC_DIMENSION_LEVELS_PUB is the supported integration point for dimension-level maintenance. It is referenced by ten other packages and is typically invoked from Balanced Scorecard setup forms, from concurrent or batch setup programs, and from custom PL/SQL that provisions or migrates scorecard hierarchies. Custom code should call only the documented public procedures and should supply the record type fields defined in the specification. The package's history of changes to locking behavior and record-type lengths indicates that callers should validate against the current patch level of the target release when migrating code between 12.1.1 and 12.2.2.