Search Results bix_pmv_dbi_utl_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.BIX_PMV_DBI_UTL_PKG is a utility package within the Oracle E-Business Suite (EBS) Daily Business Intelligence (DBI) and Performance Management framework. Its primary business function is to generate and manage the dynamic aspects of DBI/PMV (Performance Management Viewer) pages, particularly those related to Oracle Purchasing Intelligence (the "BIX" prefix denotes the Purchasing Intelligence module). The package provides a set of reusable functions and procedures that populate the parameter frameworks, construct SQL statements, and compute derived measures used to render the DBI dashboards and reports that executives and managers use to monitor procurement performance. It acts as an intermediary between the DBI presentation layer (the PMV page definitions) and the underlying transactional/fact tables.

Key Procedures and Functions

The package exposes 17 documented procedures and functions, which can be grouped by their roles:

Tables Accessed

The package directly or indirectly references three documented objects through APPS synonyms:

  • FII_TIME_DAY — the day-level time dimension table in the Financial Intelligence/DBI time dimension hierarchy. It is used by PERIOD_START_DATE and STATUS_SQL_DAYLEVEL to resolve period boundaries and build day-level status queries.
  • DUAL — the standard Oracle single-row pseudo-table, used for simple expression evaluation and parameter defaulting.
  • PLITBLM — a PL/SQL index-by table type. Its presence in the dependency list indicates the package uses this collection type internally to pass arrays of parameters or measures between its own routines.

Additionally, the dependency metadata records references to supporting PL/SQL constructs such as BIS_PMV_PARAMETERS_PUB, BIS_PMV_PAGE_PARAMETER_REC, BIS_PMV_PAGE_PARAMETER_TBL, BIS_QUERY_ATTRIBUTES, BIS_QUERY_ATTRIBUTES_TBL, POA_DBI_UTIL_PKG, FND_GLOBAL, and FND_MESSAGE, which provide parameter record structures, query attribute collections, shared DBI utilities, session context, and message handling.

Usage Notes

BIX_PMV_DBI_UTL_PKG is an internal utility rather than a public API. The ETRM metadata notes that it is referenced by 44 other database objects but does not itself reference any user-facing API. It is typically invoked indirectly: DBI/PMV page definitions and dashboard regions call the underlying BIS_PMV_PARAMETERS_PUB and related framework packages, which in turn delegate to this utility for SQL generation, measure computation, and parameter defaulting. In Oracle EBS 12.1.1 and 12.2.2, users encounter its effects when opening Purchasing Intelligence dashboards, running DBI concurrent programs that refresh summary data, or when a developer extends a DBI page and needs the standard parameter and measure logic. Direct invocation from custom code is discouraged; customization should target the documented public framework instead. Because the package is VALID in the APPS schema and is not referenced as a dependency of any other object, it can be patched or upgraded independently by Oracle DBI patches.