Search Results bis_computed_target_pvt




Overview
Explore in AI Chat

Overview

BIS_COMPUTED_TARGET_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It resides within the Oracle Balanced Scorecard (BIS) product family, which provides the performance management and strategic measurement framework used to define scorecards, targets, and key performance indicators. As indicated by the PVT (private) API classification, this package is an internal implementation unit rather than a public application programming interface. It supports the computation and retrieval of target values associated with Balanced Scorecard target definitions.

The package is not intended for direct invocation by external consumers. Instead, it operates behind other BIS packages that expose the public surface for target management. Its status is VALID in the documented environment, and the recorded metadata identifies three procedures and a single referenced table.

Key Procedures and Functions

The ETRM documentation records three procedures or functions within this package. Each is described below by purpose; parameter signatures are not enumerated in the source metadata and are therefore not reproduced here.

  • RETRIEVE_COMPUTED_TARGETS — Retrieves the set of computed target records maintained by the Balanced Scorecard target engine. This routine supplies the target values that higher-level BIS packages use when rendering or validating target definitions.
  • VALIDATE_COMPUTED_TARGET_ID — Performs validation of a computed target identifier, confirming that the supplied ID corresponds to a valid, existing computed target entry before downstream processing proceeds.
  • VALUE_ID_CONVERSION — Converts between identifier representations relevant to computed targets, reconciling internal key values with those expected by callers or dependent packages.

Tables Accessed

The documented dependency list identifies FND_FORM_FUNCTIONS as the table referenced through APPS synonyms. This is the Oracle Application Object Library table that stores form function definitions, including function names, user function names, and menu associations. Its presence indicates that BIS_COMPUTED_TARGET_PVT consults or resolves form function metadata as part of its target computation or validation logic, presumably to align computed targets with the function-level structures used in the Balanced Scorecard configuration.

In addition to the base table, the package depends on the APPS-owned BIS_UTILITIES_PUB package and the FND_API foundation package, along with the SYS STANDARD package. Those dependencies supply utility routines, the standard API error-handling and message framework, and core PL/SQL services respectively.

Usage Notes

BIS_COMPUTED_TARGET_PVT is invoked indirectly. The dependency metadata shows that it is referenced by BIS_TARGET_LEVEL_PVT and BIS_TARGET_LEVEL_VALIDATE_PVT, both of which are themselves private packages in the target management layer. Custom code or extensions that need computed target behavior should call the supported public BIS interfaces rather than this package, since its procedures are subject to change without notice between patch levels and releases.

Typical invocation paths include Balanced Scorecard setup and maintenance forms that display or validate targets, concurrent programs that compute or refresh target values, and validation routines executed when target definitions are saved. Because the package carries a PVT classification, it should be treated strictly as an internal dependency for upgrade-impact analysis and debugging rather than as an integration point. When troubleshooting target computation issues in 12.1.1 or 12.2.2, reviewing this package alongside its two referencing packages provides the clearest picture of the target validation and retrieval flow.