Search Results selected_values_tbl_type

Overview

BIS_INDICATOR_REGION_UI_PVT is a private PL/SQL package in the APPS schema that supports the user interface rendering layer of Oracle Business Intelligence System (BIS), the balanced scorecard and performance management framework delivered with Oracle E-Business Suite. Its central responsibility is to construct and manage the "Indicator Region" — the configurable region in which performance indicators, targets, dimensions, and period information are presented to end users, typically within a portlet on the EBS home page or an HTML-based dashboard. The package is classified as PVT, indicating that it is an internal implementation package not intended as a public API; external code should call the corresponding public APIs such as BIS_TARGET_PUB and BIS_UTILITIES_PUB instead.

Key Procedures and Functions

The package exposes thirty-four documented procedures and functions that fall into several functional groups:

• Period and context resolution: GETCURRENTPERIODINFO, GETNEXTPERIODINFO, GETPERFORMANCEMEASURENAME, GETORGSEQNUM, GETTIMESEQNUM, and GETORGLEVELID resolve time periods, performance measure labels, and organizational/time sequence identifiers used to scope the region content.
• Region content rendering: REGION_CONTENT, PMR_CONTENT, DISPLAY, BUILD_HTML_BANNER, GET_TRANSLATED_ICON_TEXT, and GET_IMAGES_SERVER assemble the HTML output, banner, icons, and image server references that make up the visible region.
• Indicator and dimension maintenance: SETINDICATORS, SHOWDIMENSIONS, STRDIMENSIONS, EDITDIMENSIONS, and REMOVEDUPLICATES manage which indicators and dimensions are displayed, their string representation, and duplicate elimination.
• Selection and personalization: CLEARSELECT, SETSETOFBOOKVAR, and GETTARGETURL handle user selection state, the set of books (ledger) context variable, and navigating to target detail URLs.

Tables Accessed

The package operates primarily against BIS configuration and personalization tables through APPS synonyms. BIS_INDICATORS, BIS_INDICATORS_TL, BIS_DIMENSIONS, BIS_INDICATOR_DIMENSIONS, BIS_INDICATOR_RESPS, BIS_LEVELS, BIS_LEVELS_TL, and BIS_TARGET_LEVELS supply the definitions of indicators, their translations, associated dimensions, responsible parties, and scorecard levels. BIS_USER_IND_SELECTIONS stores per-user indicator selections, while ICX_PORTLET_CUSTOMIZATIONS and AK_REGION_ITEMS hold portlet and region item configuration. FND_LANGUAGES, FND_NEW_MESSAGES, and NLS_SESSION_PARAMETERS support language, message, and session locale handling, and HTP provides the PL/SQL web toolkit routines used to emit HTML. The package also relies on SELECTED_VALUES_TBL_TYPE and depends on BIS_TARGET_PUB, BIS_UTILITIES_PUB, and BIS_UTILITIES_PVT.

Usage Notes

This package is invoked indirectly during rendering of BIS indicator portlets and scorecard dashboard regions rather than called directly by end users. Within the ETRM dependency graph it is referenced by BIS_CORRECTIVE_ACTION_PVT, BIS_PORTLET_PMREGION, and by itself, confirming its role as a UI support layer beneath the portlet manager. Because it is a private package, customizations should not call it directly; integrators should use the public BIS APIs. The behavior described here is consistent across EBS 12.1.1 and 12.2.2, since the BIS indicator region UI code base was not materially changed between those releases.