Search Results retrieve_target

Overview

BIS_PMF_DATA_SOURCE_PUB is the public API package for the Data Source Connector component within the Oracle E-Business Suite Balanced Scorecard and Performance Management framework. Its role is to expose a governed interface through which callers retrieve performance measurement data—targets, actuals, and level-based target values—for a given measure instance and dimensional context. The package header and body carry a revision marker of 115.19 (2003/02/21), placing the implementation in the early 11i lineage; it continues to ship essentially unchanged through EBS 12.1.1 and 12.2.2, where it remains owned by APPS and classified as a PUB (public) API.

The body follows the standard EBS public/private split: BIS_PMF_DATA_SOURCE_PUB performs argument validation and API plumbing, then delegates substantive work to BIS_PMF_DATA_SOURCE_PVT. The header comment block records three notable maintenance events: a 2003 change to separate local variables for IN and OUT parameters (bug 2758428); a correction preventing use of FND_API.G_MISS_xxx constants in initialization or declaration sections (bug 2774644); and a SONAR-driven conversion so that the APIs can be invoked from Java, reinforcing its role as an integration entry point rather than a form-internal utility.

Key Procedures and Functions

• Retrieve_Target_Level — Returns a target level record for a supplied measure instance and dimension level value set. The p_all_info argument defaults to FND_API.G_TRUE, allowing callers to request either the full populated record or only a subset of attributes. Internally it copies the OUT record into a local variable, invokes BIS_PMF_DATA_SOURCE_PVT.Form_Target_Level_rec, and propagates the resulting target level record back to the caller. This is the routine surfaced by the "retrieve_target_level" search.
• Retrieve_Target — Retrieves target data for a measure instance, forming the primary read path for scorecard target values.
• Retrieve_Target_Owners — Retrieves the owner or responsible-party associations attached to a target, supporting accountability reporting.
• Retrieve_Actual — Retrieves actual (period-to-date or cumulative) performance values, which are compared against targets during scorecard evaluation.
• Post_Actual — Writes or uploads actual performance data into the performance management tables, providing the inbound counterpart to the retrieval routines.

The body also declares additional public procedures (seven are documented in total), each following the same delegation pattern. Local variables and error tables such as BIS_UTILITIES_PUB.Error_Tbl_Type are used to carry status and message information back to the caller.

Tables Accessed

The supplied metadata does not enumerate base tables or APPS synonyms referenced by this package. Functionally, the retrieval routines operate against the Balanced Scorecard performance management schema—measure, target level, dimension level value, and actual value entities represented by the companion packages BIS_MEASURE_PUB, BIS_DIM_LEVEL_VALUE_PUB, and BIS_TARGET_LEVEL_PUB, whose types appear in the procedure signatures. Post_Actual writes to the actual/measure value structures. Because the package is owned by APPS and invoked through APPS synonyms, all table access is subject to standard EBS data security and MOAC/operating unit context established by the calling session.

Usage Notes

BIS_PMF_DATA_SOURCE_PUB is an integration-focused API. It is referenced by at least three other packages and, following the SONAR conversion, is designed to be called from Java as well as PL/SQL. Typical invocation paths include Balanced Scorecard application forms, concurrent programs that refresh or publish scorecard data, and custom code extending the performance management module. In EBS 12.1.1 and 12.2.2 the package is available online, so customizations should patch the file rather than modify it directly. Callers should always inspect the returned error table and status before consuming OUT records, and should avoid passing FND_API.G_MISS_xxx constants as initialization values, consistent with the documented bug fix in the package history.