Results for “bis_pmf_data_source_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.BIS_PMF_DATA_SOURCE_PVT package is a private PL/SQL API belonging to the Oracle E-Business Suite Balanced Scorecard and Performance Management Framework (BIS/PMF) module. In the context of EBS 12.1.1 and 12.2.2, it functions as an internal data source engine that supports the Performance Management Framework's ability to define, resolve, and populate targets, actuals, and measures used in scorecard and planning constructs. The package is classified as a PVT (private) API, meaning it is not intended for direct invocation by external or customer code, but rather serves as the implementation layer consumed by public APIs such as BIS_PMF_DATA_SOURCE_PUB. Its primary business role is to reconcile the definitions of performance targets and actuals against the hierarchical dimensions, levels, and measures maintained within the Performance Management Framework, thereby enabling balanced scorecard computations and generic planner functionality.

Key Procedures and Functions

The ETRM metadata documents seven procedures/functions within this package. Each supports a specific stage of transforming PL/SQL record structures into the data source layer used by BIS reporting components:

• FORM_TARGET_LEVEL_REC — Constructs or populates a target level record, aligning target definitions with their associated dimensional levels.
• FORM_TARGET_REC — Builds the target record structure required by downstream BIS target processing and persistence.
• FORM_ACTUAL_REC — Assembles the actual results record, providing the counterpart to target data for scorecard comparisons.
• FORM_MEASURE_INSTANCE — Creates a measure instance, binding a measure definition to a specific data context or period.
• FORM_DIM_LEVEL_VALUE_TBL — Populates a table of dimension level values, enabling hierarchical slicing of performance data.
• FORM_NOTIFIER_REC — Builds a notifier record, supporting alert or notification propagation within the PMF data flow.
• SYNC_TARGET_MEASURE_OWNERS — Synchronizes ownership between targets and measures, ensuring that ownership metadata remains consistent.

Tables Accessed

The documented metadata does not enumerate specific base tables; it records that table access occurs through APPS synonyms. The package's dependencies on BIS_ACTUAL_PUB, BIS_DIM_LEVEL_VALUE_PUB, BIS_MEASURE_PUB, BIS_TARGET_LEVEL_PUB, BIS_TARGET_PUB, and BIS_UTILITIES_PUB indicate that its data reads and writes are mediated through these public packages rather than direct DML against BIS tables. Consequently, the underlying tables involved correspond to the BIS Performance Management schema — target, target level, measure, dimension level value, and actual tables — accessed indirectly via the public API layer. This design ensures that business rules, validation, and security enforced by the public packages are consistently applied.

Usage Notes

Because BIS_PMF_DATA_SOURCE_PVT is a private package, it is not invoked directly from Oracle Forms, concurrent programs, or custom extensions. It is referenced by BIS_COMPUTED_ACTUAL_PVT, BIS_GENERIC_PLANNER_PVT, and the public wrapper BIS_PMF_DATA_SOURCE_PUB, and it also references itself for internal recursion. Typical invocation flows therefore occur in the background when a user operates the Balanced Scorecard or Performance Management Framework forms, or when the generic planner concurrent processes execute. Customers and integrators seeking to extend PMF functionality should call the corresponding public APIs (BIS_PMF_DATA_SOURCE_PUB and the BIS_*_PUB packages) rather than this private implementation. In both EBS 12.1.1 and 12.2.2, the package status remains VALID and its behavior is consistent, with dependency on the standard SYS.STANDARD package confirming it is a normal compiled PL/SQL unit.