Search Results bis_actual_validate_pvt




Overview
Explore in AI Chat

Overview

APPS.BIS_ACTUAL_PUB is a public PL/SQL API package in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, residing in the APPS schema and classified as a PUB (public) interface. It belongs to the Business Intelligence System (BIS) family of packages, which underpins the Oracle Balanced Scorecard and related performance-management functionality within EBS. The package provides the programmatic entry points through which callers persist, retrieve, and validate "actual" values — the measured results recorded against scorecard indicators for a given period. In ETRM terms, the package exposes operations for posting actual data, retrieving single or multiple actual records, fetching the latest available actual, and validating an actual before it is committed. The package status is documented as VALID, indicating that all stored PL/SQL objects within it compiled successfully against the referenced dependencies.

Key Procedures and Functions

The documented interface comprises seven procedures and functions:

  • POST_ACTUAL — Persists an actual value record, typically the write entry point used after a validated actual is ready to be committed into the BIS data structures.
  • RETRIEVE_ACTUAL — Returns a single actual record, generally identified by its primary keys or indicator context.
  • RETRIEVE_ACTUALS — Returns a set of actual records, supporting multi-row retrieval for a given query context.
  • RETRIEVE_LATEST_ACTUAL — Returns the most recent single actual value for an indicator or period, useful for "current state" displays.
  • RETRIEVE_LATEST_ACTUALS — Returns the latest actual value across a collection of indicators, supporting dashboard and summary views.
  • RETRIEVE_USER_SELECTIONS — Retrieves user-defined selections relevant to the actual data being processed, supporting personalised reporting or filtering.
  • VALIDATE_ACTUAL — Performs validation logic against an actual record prior to posting, enforcing business rules that the downstream PVT layer relies upon.

Parameter lists are not reproduced here; callers should reference the package specification for exact signatures.

Tables Accessed

The only documented table referenced through APPS synonyms is PLITBLM. This is a generic BIS utility table used to hold temporary or working data during processing. The absence of direct references to a dedicated actual table implies that persistent writes are delegated to private-layer packages such as BIS_ACTUAL_PVT and BIS_COMPUTED_ACTUAL_PVT, while the public package coordinates orchestration and retrieval. The table supports staging of intermediate results consumed by the retrieval and validation routines.

Usage Notes

BIS_ACTUAL_PUB is referenced by nineteen other packages, including BIS_ACTUAL_PVT, BIS_ACTUAL_VALIDATE_PVT, BIS_COMPUTED_ACTUAL_PVT, BIS_GENERIC_PLANNER_PVT, BIS_PMF_DATA_SOURCE_PUB, BIS_PMV_PMF_PVT, BIS_PORTLET_PMREGION, BIX_ALERT, and the product alert packages GL_BIS_ALERTS_PKG, HR_BIS_ALERTS, OE_BIS_ALERTS, POA_BIS_ALERTS, WIP_BIS_UTZ_ALERT, and WIP_BIS_YDSP_ALERT. This dependency footprint confirms that the package is invoked both interactively — through Balanced Scorecard forms, PMF region portlets, and alert mechanisms — and programmatically by concurrent or background processes that generate and validate scorecard actuals. The direct dependency on FND_API indicates the package observes Oracle Application Object Library API conventions, including standard return-status handling. Custom code should call the public procedures rather than the underlying private packages, since BIS_ACTUAL_PUB is the supported interface and its dependencies are already validated in the ETRM baseline. When invoking VALIDATE_ACTUAL, callers should follow with POST_ACTUAL only upon a successful validation result.