Search Results retrieve_actual_from_pmv




Overview
Explore in AI Chat

Overview

APPS.BIS_COMPUTED_ACTUAL_PVT is a private PL/SQL package within the Oracle E-Business Suite Business Intelligence System (BIS) schema, classified under the ETRM taxonomy as a PVT (private) API object. It provides the internal programmatic foundation for the computation, validation, and retrieval of "computed actual" values within the BIS/PMF (Performance Management Framework) subsystem. In this context, a computed actual is a measured or derived business result — such as revenue, cost, or quantity — that is associated with a specific dimension level value so that it may be compared against targets, plan figures, or other measures in a performance scorecard. The package encapsulates the validation and conversion logic required before such values can be persisted or displayed, and it mediates between the public BIS APIs and the underlying metadata that describes scorecard regions and dimension levels. As a private package, it is not intended for direct customer invocation; it exists to support sibling public packages such as BIS_ACTUAL_PUB, BIS_MEASURE_PUB, BIS_DIM_LEVEL_VALUE_PUB, and BIS_UTILITIES_PUB, all of which it references. ETRM records indicate the object is VALID in both the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The documented interface of BIS_COMPUTED_ACTUAL_PVT comprises nine named program units:

  • RETRIEVE_ACTUAL_FROM_PMV — retrieves an actual value sourced from the PMV (Performance Management Viewer) data structures, reconciling the PMV representation with the computed-actual model used by the BIS framework.
  • RETRIEVE_COMPUTED_ACTUAL — returns the computed actual for a given context, acting as the principal read accessor for this entity.
  • VALIDATE_COMPUTED_ACTUAL — performs integrity validation on a computed actual prior to processing, confirming that the record conforms to the expected business rules.
  • VALIDATE_REQUIRED_FIELDS — verifies that all mandatory attributes are populated, providing a reusable required-field check invoked by the other validation routines.
  • VALUE_ID_CONVERSION — translates between internal value identifiers and their external or alternate representations, ensuring consistent key handling across the BIS APIs.
  • GET_RELATED_OBJECTS — resolves the set of related metadata objects associated with a computed actual, supporting dependency and navigation logic.
  • IS_TIME_DIMENSION_LEVEL — determines whether a specified dimension level belongs to a time dimension, which governs time-based aggregation and comparison behaviour.
  • GET_REGION_USING_FUNCTION — identifies the scorecard region associated with a given function, linking the computed actual to its presentation context.
  • GET_DIM_LEVEL_SHORT_NAME — returns the short name of a dimension level for display and labelling purposes.

Tables Accessed

The package reads the following objects through APPS synonyms. AK_REGIONS and AK_REGION_ITEMS are the Oracle Common Application Components (AK) metadata tables that define scorecard regions and their constituent items; they are consulted to resolve the region associated with a function and to understand presentation structure. FND_FORM_FUNCTIONS is the Oracle Application Object Library table describing form functions, used to map functions to regions. PLITBLM is a BIS/OLAP support table accessed in connection with computed-actual retrieval. All access is read-oriented; persistence of computed actuals is delegated to the public BIS APIs referenced by this private package.

Usage Notes

BIS_COMPUTED_ACTUAL_PVT is invoked indirectly rather than through direct customer calls. ETRM records that it is referenced by BIS_PMF_DATA_SOURCE_PUB and BIS_PMF_REG_SERVICE_PVT, both of which expose higher-level PMF data-source and region-service functionality that ultimately serves the Performance Management Framework user interface. Typical invocation paths therefore include scorecard and PMV pages rendered through the BIS framework, PMF registration and data-source processing, and any custom code that calls the public BIS_ACTUAL_PUB, BIS_MEASURE_PUB, or BIS_DIM_LEVEL_VALUE_PUB APIs. Because the package is classified PVT and depends on FND_API and the STANDARD profile, its contract is considered internal; customisations should target the public wrappers to remain upgrade-safe across 12.1.1 and 12.2.2.