Search Results bis_pmv_query_pvt




Overview
Explore in AI Chat

Overview

BIS_PMV_SESSION_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle E-Business Suite Performance Management Viewer (PMV) subsystem. PMV is the reporting and dashboarding engine underlying Oracle Balanced Scorecard, Daily Business Intelligence, and the broader Oracle EBS intelligence framework. The "PVT" classification indicates that this is an internal, private package rather than a public API; it is not intended for direct invocation by external callers, and its specification is subject to change without notice across releases. The package manages session state for the PMV runtime. When a user launches a PMV-based dashboard or scorecard page, the session layer must establish context — identifying the user, the active responsibility, the selected portal or viewer configuration, and the parameters that govern the current query execution. BIS_PMV_SESSION_PVT encapsulates the persistence and retrieval of that context, shielding the higher-level public packages from the mechanics of session storehouse maintenance.

Key Procedures and Functions

The ETRM metadata for this object records no individually documented procedures or functions. As a private ("PVT") package, its callable surface is deliberately undocumented in the public sense; Oracle publishes only the metadata for public APIs and selected internals. The dependency listing confirms that the package references only SYS.STANDARD, meaning it does not directly manipulate base tables or other APPS packages through its own dependency chain — the session state it governs is held in PL/SQL structures or transient session tables managed elsewhere. Because no procedure signatures are recorded, no parameter lists are reproduced here. Practically, the package provides the session initialization, attribute get/set, and session cleanup operations that the PMV public packages depend on.

Tables Accessed

No tables are documented as referenced by this package via APPS synonyms. Its only recorded dependency is SYS.STANDARD, the built-in PL/SQL package that provides default datatypes and the standard exception set. This suggests the session package operates primarily on in-memory session state and on data supplied by its callers, rather than issuing direct DML against PMV configuration or results tables. Any persistent session records are written or read indirectly through the packages that invoke it.

Usage Notes

BIS_PMV_SESSION_PVT sits beneath the PMV public layer. The metadata shows it is referenced by BIS_PMV_PARAMETERS_PVT, BIS_PMV_PORTAL_UTIL_PUB, BIS_PMV_QUERY_PVT, and BIS_PMV_SCHED_PARAMETERS_PVT — four packages covering parameter handling, portal utilities, query execution, and scheduled parameter processing. This placement means the session package is invoked implicitly whenever a user opens a PMV portal, submits a PMV query, or when a scheduled PMV program establishes its own session context. The user search term "bis_pmv_query_pvt" identifies a sibling package, BIS_PMV_QUERY_PVT, which is itself a dependent of BIS_PMV_SESSION_PVT; the two are frequently encountered together during debugging of PMV runtime behaviour. Custom code should not call BIS_PMV_SESSION_PVT directly. Diagnostics should proceed through the public PMV packages or through FND logging, since private package interfaces are unsupported and may be refactored between 12.1.1 and 12.2.2.