Search Results bis_pmv_drill_pub

Overview

APPS.BIS_PMV_DRILL_PUB is a public PL/SQL package body within the Oracle E-Business Suite Business Intelligence System (BIS) schema, classified as a PUB (public) API per the ETRM 12.1.1 documentation. Its name and structure indicate it belongs to the Performance Management Viewer (PMV) framework, which powers the interactive dashboards, balanced scorecards, and analytic regions delivered through Oracle EBS System Administrator and Intelligence components. The package provides the server-side engine that resolves drill-across navigation requests raised when a user clicks a hyperlinked cell, bar, or data point inside a published PMV or Daily Business Intelligence (DBI) region. Rather than executing an ad-hoc query, the package translates the clicked context — dimension members, measure values, and time parameters — into a validated navigation request that the front-end framework can follow to a target page, report, or region. Because the object is a public package body owned by APPS, it is exposed to other application-layer code and to Oracle Forms-based and OAF-based dashboards that depend on the shared BIS infrastructure.

Key Procedures and Functions

The ETRM metadata documents a single public program unit in this package body:

• DRILLACROSS — The principal entry point for drill-across processing. It receives a user-initiated navigation request from a PMV/DBI region and resolves it into a target destination, applying parameter validation and context mapping before returning the appropriate navigation target to the caller. The procedure delegates parameter checks to APPS.BIS_PARAMETER_VALIDATION, which the dependency listing confirms as a referenced object. No parameter list is reproduced here, consistent with the documented metadata.

The package body references the standard SYS.STANDARD package and its own specification, reflecting ordinary PL/SQL compilation dependencies. The ETRM record shows no other documented procedures or functions, so no additional program units are asserted.

Tables Accessed

The documented ETRM record for APPS.BIS_PMV_DRILL_PUB lists no direct table references through APPS synonyms. This is consistent with the package's role as a navigation and parameter-resolution layer rather than a data-retrieval layer: the actual drill target content is resolved by downstream BIS views, PMV definitions, and DBI summary objects invoked after DRILLACROSS returns. Parameter validation logic is delegated to APPS.BIS_PARAMETER_VALIDATION, which is the documented dependency responsible for any underlying table access. The absence of catalogued table dependencies should be treated as metadata rather than proof that no SQL executes at runtime.

Usage Notes

This package is invoked indirectly by the Oracle EBS dashboard and PMV infrastructure rather than by end users directly. Typical invocation paths include:

• Interactive drill-across actions in PMV regions, Balanced Scorecard pages, and DBI dashboards, where the framework calls DRILLACROSS to translate a clicked data point into a target navigation request.
• Oracle Forms and OA Framework pages that embed BIS analytic regions and rely on the shared PMV navigation API.
• Custom or extension code that follows the documented PUB contract to trigger programmatic drill-across navigation, provided the caller supplies a validated parameter set.

Because the ETRM dependency record shows that APPS.BIS_PMV_DRILL_PUB is not referenced by any other database object, it is a leaf-level public API: changes to its signature or behaviour carry limited internal blast radius but may affect any external caller bound to the PUBLIC contract. In 12.1.1 and 12.2.2 the package remains VALID and is expected to be present in every EBS instance with the BIS/DBI product family installed.