Search Results bis_pmv_actual_pub

Overview

BIS_PMV_ACTUAL_PUB is the public application programming interface (API) package body owned by the APPS schema in Oracle E-Business Suite. The _PUB suffix designates it as a published, callable interface, in contrast to its private implementation counterpart, BIS_PMV_ACTUAL_PVT, which holds the internal logic. The package belongs to the Business Intelligence System (BIS) product family, which provides the underlying infrastructure for the Oracle EBS Daily Business Intelligence (DBI) and Performance Management (PMV) reporting frameworks. Its business function is to expose actual-value retrieval services that feed performance management dashboards, KPI comparisons, and fact-based analytics. In release 12.1.1 and 12.2.2 the object is documented as VALID, confirming that it compiles cleanly and is available at runtime.

Key Procedures and Functions

The ETRM metadata documents a total of three procedures and functions, of which GET_ACTUAL_VALUE is explicitly recorded. GET_ACTUAL_VALUE is the principal public entry point of the package: it returns the "actual" measure value for a given performance management context, distinguishing actual results from targets or prior-period figures used elsewhere in the PMV model. As the naming implies, its purpose is to resolve and deliver actual data to the calling layer rather than to persist or transform it. Consistent with the PUB/PVT design pattern, these public routines are thin wrappers that delegate the substantive work to BIS_PMV_ACTUAL_PVT. Parameter lists are not reproduced here; consumers should reference the package specification in the database to confirm signatures.

Tables Accessed

The documented dependency list for BIS_PMV_ACTUAL_PUB does not enumerate any base tables accessed directly through APPS synonyms. The package references the following objects: the APPS schema itself, its own package body (BIS_PMV_ACTUAL_PUB), the private package body BIS_PMV_ACTUAL_PVT, and the SYS-owned STANDARD package. This dependency profile indicates that the public package performs little or no direct SQL against application tables; instead, all fact and dimension access is encapsulated within BIS_PMV_ACTUAL_PVT. Any data reads or writes therefore occur one layer below, in the private package, where the PMV summary and fact tables are manipulated. This separation shields calling code from changes to the underlying PMV schema.

Usage Notes

BIS_PMV_ACTUAL_PUB is not referenced by any other database object according to the metadata, which identifies it as a top-level consumer-facing API invoked from outside the database rather than from a PL/SQL dependency chain. It is typically called by:

• Business Intelligence and Performance Management concurrent programs that populate or refresh PMV dashboard data.
• DBI/PMV reporting forms and region logic that display actual-versus-target comparisons.
• Custom PL/SQL code or extracts that require the same actual-measure semantics used by the standard dashboards.
• Internal PMV orchestration code that dispatches to the published API to preserve upgrade-safe behavior.

Because it is referenced by two other packages in the broader PMV layer, deployments and patches affecting this package should be regression-tested against those callers. As with all published APIs, direct modification of the package body is not supported; integrators should consume its documented interfaces and rely on Oracle-supplied implementations across 12.1.1 and 12.2.2.