Search Results bis_indicator_region_pvt




Overview
Explore in AI Chat

Overview

BIS_INDICATOR_REGION_PVT is the private implementation package body for the Oracle E-Business Suite Balanced Scorecard / Business Intelligence System (BIS) indicator region functionality, owned by the APPS schema. It operates as the internal counterpart to the public package BIS_INDICATOR_REGION_PUB, which delegates calls into this private body. The package manages the association between indicators, target levels, and individual user selections within the BIS performance management framework, allowing end users to personalise which indicators appear in their scorecard regions and to persist those selections across sessions.

In Oracle EBS 12.1.1 and 12.2.2, the BIS schema underpins the Daily Business Intelligence and Balanced Scorecard reporting layers. The indicator region is the presentation construct through which selected indicators and their target levels are surfaced to a user on a dashboard. This package provides the PL/SQL logic that validates, stores, retrieves, and removes user-specific indicator selections, and it exposes APIs classified as PVT (private), meaning they are intended for invocation by the public wrapper rather than directly by external callers.

Key Procedures and Functions

The documented package exposes eight procedures and functions, summarised below by purpose. Parameter lists are intentionally not reproduced here.

  • CREATE_USER_IND_SELECTION — Inserts a new user-specific indicator selection record, establishing the link between a user, an indicator, and its associated selection attributes.
  • RETRIEVE_USER_IND_SELECTIONS — Queries and returns the set of indicator selections previously saved by a given user, typically for rendering the indicator region.
  • UPDATE_USER_IND_SELECTION — Modifies an existing user indicator selection, such as changes to display order, target level, or other configurable attributes.
  • DELETE_USER_IND_SELECTIONS — Removes one or more stored selections for a user, supporting reset or cleanup operations.
  • RETRIEVE_USER_LABELS — Returns the labels or display captions associated with user indicator selections, used for presentation in the region.
  • VALIDATE_USER_IND_SELECTION — Performs validation on a proposed selection prior to persistence, ensuring the selection is coherent and permitted.
  • VALIDATE_REQUIRED_FIELDS — Checks that mandatory attributes are present before an operation proceeds, returning an error where required data is missing.

These routines follow the standard EBS API convention of performing validation, then DML, with error signalling through the shared FND_API utilities.

Tables Accessed

The package reads and writes several BIS tables accessed through APPS synonyms, together with core Oracle and EBS objects.

  • BIS_USER_IND_SELECTIONS — The primary transactional table holding per-user indicator selections; the target of create, update, and delete operations and the source for retrieval.
  • BIS_USER_IND_SELECTIONS_S — The corresponding sequence that supplies primary key values for new selection records.
  • BIS_INDICATORS — The indicator definition table, joined to resolve indicator attributes for validation and display.
  • BIS_TARGET_LEVELS — Provides target level definitions associated with indicators and selections.
  • FND_USER and FND_USER_RESP_GROUPS — Used for user identity and responsibility context resolution.
  • DUAL, HTP, PLITBLM, STANDARD — Standard Oracle plumbing objects used for expression evaluation, HTML output, and PL/SQL table handling.

The package also calls the companion packages BIS_DIM_LEVEL_VALUE_PUB/PVT, BIS_TARGET_LEVEL_PUB/PVT, BIS_UTILITIES_PUB/PVT, FND_API, and FND_GLOBAL, reflecting its position within the broader BIS API stack.

Usage Notes

Because this is a PVT package, direct invocation from custom code is discouraged in favour of the public interface BIS_INDICATOR_REGION_PUB, which forwards calls into this body. Typical invocations originate from the BIS scorecard and dashboard user interface when a user adds, edits, or removes indicators from a region, or when the region is refreshed to retrieve saved selections. The package is not referenced by any other database object and is documented as referenced only through its public counterpart, confirming its role as an internal implementation unit. When troubleshooting the user search term bis_user_ind_selections_s, note that the sequence is referenced here for key generation and is normally not queried directly.