Search Results bis_generic_planner_pvt




Overview
Explore in AI Chat

Overview

BIS_GENERIC_PLANNER_PVT is a private PL/SQL package in the APPS schema that forms part of the Oracle Business Intelligence System (BIS), the foundation of the Daily Business Intelligence (DBI) and Performance Management Framework (PMF) product family. Its central role is to orchestrate generic planner processing — evaluating performance measures, dimension-level values, targets, and actuals against defined business rules, and generating planner requests that drive alerts, corrective actions, and KPI exception reporting. The "PVT" classification denotes that this is an internal implementation package intended for use by other BIS components rather than direct end-user invocation.

The package is central to the way DBI/PMF translates raw transactional data into actionable intelligence. Rather than a thin utility, it acts as the shared planner engine invoked by several higher-level BIS packages, ensuring a consistent approach to computing plan-versus-actual comparisons and exception thresholds across the BIS product set.

Key Procedures and Functions

  • SERVICE_PLANNER_REQUEST — Processes or services a planner request. This is the primary entry point that external BIS services call to request generic planner processing, coordinating the comparison logic and orchestrating downstream handling of the resulting planning output.
  • COMPARE_VALUES — Performs the comparison between values associated with a planning context, such as actuals versus targets or dimension-level values versus measures. Its comparison results underpin the exception calculations used by the BIS alert and corrective-action infrastructure.

Three procedures/functions are documented in total; the metadata lists the names above without exposing parameter lists, and no parameter signatures are reproduced here.

Tables Accessed

The ETRM metadata for this package does not enumerate directly referenced base tables or APPS synonym tables. Its data access is instead expressed through dependencies on the BIS public API packages: BIS_ACTUAL_PUB (actual/measure fact values), BIS_TARGET_PUB (target values for comparison), BIS_MEASURE_PUB (measure definitions and metadata), and BIS_DIM_LEVEL_VALUE_PUB (dimension-level value definitions). These packages encapsulate the underlying BIS schema tables, so BIS_GENERIC_PLANNER_PVT reads and evaluates plan data indirectly through them. No direct table access is documented.

Usage Notes

BIS_GENERIC_PLANNER_PVT is referenced by four other packages: BISVIEWER_PMF, BIS_ALERT_SERVICE_PVT, BIS_CORRECTIVE_ACTION_PVT, and BIS_PMV_PMF_PVT, and is also self-referenced. This dependency pattern confirms it is an internal service layer invoked by the BIS viewer, alert service, corrective action, and PMV/PMF processing components rather than being called directly from Oracle Forms or a standalone concurrent program.

Typical invocation occurs during DBI/PMF data refresh and planner runs, where higher-level BIS processes evaluate targets against actuals and propagate exceptions to the alerting framework. Because the package is a private (PVT) API and depends on the APPS schema, customizations should avoid direct calls; instead, integrators should use the supported public BIS APIs such as BIS_ACTUAL_PUB, BIS_TARGET_PUB, and BIS_MEASURE_PUB. Both Oracle EBS 12.1.1 and 12.2.2 maintain this package as VALID, and its behavior is consistent across both releases given that it relies on the underlying BIS public API layer rather than release-specific base tables.