Search Results get_dimension_display_value




Overview
Explore in AI Chat

Overview

BIS_TARGET_UTIL is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its classification in the ETRM repository is UTIL, indicating that it provides reusable helper routines rather than a full business API. The package belongs to the Oracle Balanced Scorecard / Business Intelligence System (BIS) product family, which supports enterprise performance management, indicator tracking, and target-level definitions. The central purpose of BIS_TARGET_UTIL is the dynamic creation and removal of database views that expose indicator and target-level data, plus ancillary routines for resolving dimension display values and validating responsibility and organization access. The package is declared with AUTHID CURRENT_USER, so all dynamically generated DDL and DML execute under the privileges of the calling session rather than the package owner. This matters because the package manipulates views at runtime and must respect the caller's schema and security context.

Key Procedures and Functions

The package exposes six documented procedures, each following the standard EBS API error-handling convention of returning x_return_status, x_msg_count, and x_msg_data out parameters, with a p_msg_init flag defaulting to FND_API.G_TRUE to control message stack initialization.

  • Create_Ind_Level_View — Generates a database view for a specified indicator level, identified by p_ind_level_name. This supports level-specific reporting structures.
  • Create_Indicator_views — Creates the view(s) associated with a single indicator named by p_indicator_name. This is the procedure most closely tied to the user search term create_indicator_views.
  • Create_BIS_views — Constructs the complete set of BIS views for the environment; it takes no name or level argument, implying a bulk or system-wide generation operation.
  • Drop_Ind_Level_view — Removes an indicator-level view by its numeric p_target_level_id, reversing the work of Create_Ind_Level_View.
  • Get_Dimension_Display_Value — Resolves a dimension level value identifier into its human-readable display name, returning it through x_dim_level_value_name. This is a lookup helper used by reporting and UI layers.
  • Validate_Resp_Org — Validates whether a given responsibility and organization combination is accessible to a specific user, supporting security enforcement for BIS content.

Tables Accessed

The package operates against three documented BIS tables, accessed through APPS synonyms, plus the Oracle-supplied DBMS_SQL package.

  • BIS_INDICATORS — Stores indicator definitions; read to obtain the metadata required to construct indicator views.
  • BIS_LEVELS — Holds level definitions used to build indicator-level and dimensional views.
  • BIS_TARGET_LEVELS — Contains target-level definitions, keyed by target level id, and is referenced when creating or dropping indicator-level views.
  • DBMS_SQL — The dynamic SQL engine used to parse and execute the generated CREATE VIEW and DROP VIEW statements, since the DDL text is assembled at runtime.

Usage Notes

BIS_TARGET_UTIL is an internal utility rather than a public user-facing API. It is typically invoked indirectly by Oracle Balanced Scorecard setup and administration screens, concurrent programs that regenerate indicator and target views after configuration changes, and any custom code that must refresh or drop BIS view definitions. Because it issues DDL through DBMS_SQL under AUTHID CURRENT_USER, callers require the appropriate CREATE VIEW and DROP VIEW privileges. The package is not referenced by any other package in the documented metadata, confirming its role as a leaf-level utility. The header timestamp (115.12, 1999) indicates the source predates Release 12 and has been carried forward with minimal change into 12.1.1 and 12.2.2. Administrators should invoke these routines during controlled maintenance windows, as recreating views can invalidate dependent objects and cause cursor invalidation.