Search Results get_notify_rpt_url

Overview

BIS_PMV_PMF_PVT is a private PL/SQL package in the APPS schema of Oracle E-Business Suite, classified under the ETRM API taxonomy as a "PVT" (private) package. It belongs to the Business Intelligence System (BIS) product family, and the "PMV" segment of its name associates it with the Performance Management Viewer, the framework that renders business intelligence scorecards, dashboards, and performance metrics inside the EBS application. As a private package, it is not intended as a published extension point; it supplies internal helper logic consumed by the public BIS viewer and query-processing packages.

The package's functional center of gravity is target management and notification for performance metrics. It resolves metric target values, computes dimension-level totals, evaluates tolerance thresholds against actual results, and constructs notification report URLs. These operations support the alerting and exception-reporting side of the Performance Management framework, where a business user monitors a metric, compares the actual against a target, and receives a notification when the variance falls outside an acceptable band. The status recorded in the ETRM extract is VALID, confirming the package is compiled and operational in the documented 12.1.1 environment.

Key Procedures and Functions

The ETRM metadata documents seven callable units within the package:

• GET_TARGET — Retrieves the target value associated with a performance metric, forming the baseline against which actual results are compared.
• GET_TARGET_NEW — A later variant of the target retrieval routine, providing the target resolution logic used by current code paths.
• GETTOTALDIMVALUE — Returns the total value for a given dimension, enabling aggregate summaries across dimension members rather than a single member's value.
• GETTOTALDIMLEVELNAME — Supplies the name of the dimension level for which totals are calculated, giving the viewer the labeling information needed to present aggregate rows correctly.
• TOLERANCE_TEST — Evaluates a value against its target and tolerance thresholds, determining whether the metric is within acceptable limits or constitutes an exception.
• GET_NOTIFY_RPT_URL — Builds the URL used to invoke the notification report associated with a metric or its exception.
• GET_NOTIFY_RPT_RUN_URL — Builds the corresponding URL for running that notification report, completing the navigation link delivered to the user.

No parameter lists are asserted here; the metadata documents unit names and purpose only.

Tables Accessed

The package reaches its data through APPS synonyms, a standard EBS design that isolates code from the underlying schema. The documented tables and utilities are:

• BIS_DIMENSIONS — Stores dimension definitions, supplying the structure against which dimensional totals and values are resolved.
• BIS_LEVELS — Stores level definitions within the BIS hierarchy, supporting the level-name resolution used in aggregate presentation.
• BIS_NOTIFICATION_ID_S — The sequence that generates identifiers for BIS notification records.
• AK_REGION_ITEMS — The Oracle Application Framework (OA Framework) region item repository, referenced when the package assembles the user-interface context for notification output.
• DUAL — Used for single-row expression evaluation typical of PL/SQL utility logic.
• HTP — The PL/SQL HTML generation toolkit, used to emit the HTML fragments that make up notification report links.
• UTL_HTTP — The Oracle-supplied HTTP utility, used for outbound HTTP calls related to notification URL processing.

Direct dependencies listed in the ETRM extract are limited to SYS and STANDARD, reflecting only the package's core PL/SQL dependencies.

h4>Usage Notes

Because BIS_PMV_PMF_PVT is a private package, it is never called directly from forms, concurrent program definitions, or customer extensions. The ETRM metadata records that it is referenced by two other packages: BIS_PMV_QUERY_PVT, which handles query processing for the Performance Management Viewer, and BIS_PMV_PMF_PVT's own dependent code paths. The BISVIEWER application object also references it. Invocation therefore occurs indirectly, whenever a user opens a performance dashboard or scorecard region, when metric targets are resolved for display, when dimensional totals are computed for aggregate rows, when tolerance evaluation determines exception status, and when the notification framework produces a report link. In the 12.1.1 and 12.2.2 environments, this behavior is unchanged. Administrators investigating metric target or notification issues should examine it read-only and treat any modification as unsupported, since the package is Oracle-maintained internal code rather than a documented API.