Search Results bis_notification_id_s

Overview

The APPS.BIS_PMV_ACTUAL_PVT package body is a private (PVT-classified) PL/SQL implementation within the Oracle E-Business Suite Business Intelligence System (BIS) module. It supports the Page/Portlet Materialized View (PMV) framework that underpins the Oracle EBS Applications Dashboard and related HTML-based performance and diagnostics pages. Specifically, this package is responsible for retrieving and computing "actual" values that are displayed alongside targets, thresholds, or goals within dashboard regions.

In the context of a search for bis_notification_id_s, this package is significant because it directly references the BIS_NOTIFICATION_ID_S sequence. That sequence generates unique notification identifiers used by the BIS alerting and notification subsystem when dashboard metrics trigger exceptions or threshold breaches. The package body is VALID in the documented 12.1.1 / 12.2.2 metadata and is classified as private (PVT), meaning it is intended for internal use by related BIS packages rather than direct invocation by end users or external customizations.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within this package body. Their purposes are as follows:

• GET_ACTUAL_VALUE — Retrieves the actual measured value for a given dashboard metric, serving as the primary entry point for obtaining current performance figures.
• GET_ACTUAL_VALUE_PLSQL — A PL/SQL variant of the actual-value retrieval logic, used when the underlying query is expressed as native PL/SQL rather than a stored SQL statement.
• STORE_PARAMETERS — Persists or caches runtime parameters supplied by the calling page or portlet for subsequent value calculations.
• SETUP_BIND_VARIABLES — Establishes bind variables required during dynamic SQL execution within the actual-value computation.
• GET_CALCULATED_VALUE — Computes a derived value based on stored parameters and base metrics, distinct from a raw actual value.
• SORTBY_BASE_COLUMN_LENGTH — A utility routine supporting ordering logic tied to base column length, used in presentation of dashboard result sets.

Note that the metadata does not document explicit parameter lists for these routines; they are described here by purpose only.

Tables Accessed

The package references several objects via APPS synonyms:

• AK_REGIONS and AK_REGION_ITEMS — Oracle Application Framework (OAF/AK) region definitions, used to resolve the layout and items associated with a dashboard region.
• BIS_NOTIFICATION_ID_S — The sequence referenced by the user's search, providing unique IDs for BIS notifications generated from dashboard metric evaluations.
• DBMS_SQL and DUAL — Used for dynamic SQL execution and simple singleton queries.
• PLITBLM — A PL/SQL table type used for in-memory collection handling.

Usage Notes

Because BIS_PMV_ACTUAL_PVT is not referenced by any database object per the metadata, it is typically invoked indirectly — through sibling packages such as BIS_PMV_PARAMETERS_PVT, BIS_PMV_QUERY_PVT, and BIS_PMV_UTIL, which are listed as dependencies. The package is used when rendering BIS dashboard regions that display actual-versus-target performance values. Custom code should avoid calling it directly, relying instead on the higher-level BIS PMV packages, and should never modify the sequence reference, as notification IDs are consumed by the alerting framework.