Search Results validate_measure

Overview

BIS_MEASURE_PUB is the public PL/SQL API package owned by APPS that governs the creation and lifecycle management of Performance Measurements within the Oracle EBS Balanced Scorecard and performance management framework. The package header identifies it as the "Public API for creating and managing Performance Measurements," a role it has fulfilled since its original creation in November 1998. It is classified as a PUB package, meaning its procedures are intended for invocation by external callers — concurrent programs, forms, and custom code — rather than being restricted to internal implementation use.

The package underwent substantial evolution across releases. Early history entries record fixes for bugs 1850860 and enhancement 2440739, followed by Measure Definer (PMD) support in 2003, removal of hard-coded lengths for names and descriptions (bug 2910316), multilingual synchronization of measures (bug 3160325), and the addition of WHO audit columns to the record type (bug 3891748). The July 2004 entry documents the modification of the create and update measure APIs to accept a default p_owner parameter, which is directly relevant to users searching for updt_pm_owner.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions:

• CREATE_MEASURE — Creates a new performance measure definition, accepting an owner parameter following the July 2004 enhancement.
• UPDATE_MEASURE — Modifies an existing measure definition, including owner assignment.
• DELETE_MEASURE — Removes a measure definition.
• VALIDATE_MEASURE — Performs validation logic against a measure definition prior to persistence.
• RETRIEVE_MEASURES — Returns a set or collection of measure definitions.
• RETRIEVE_MEASURE — Returns a single measure definition.
• RETRIEVE_MEASURE_DIMENSIONS — Returns the dimensions associated with a measure.
• TRANSLATE_MEASURE — Populates translated (TL) content for a measure.
• TRANSLATE_MEASURE_BY_LANG — Performs translation for a specified language, supporting the multilingual synchronization introduced for bug 3160325.
• LOAD_MEASURE — Loads measure data, typically for bulk or migration scenarios.
• UPDT_PM_OWNER — Updates the owner of a performance measure, the specific routine matching the user's search term. It reflects the owner-defaulting capability added to the create/update APIs in 2004.
• GET_CUSTOMIZED_ENABLED — Returns the enabled/customization status of a measure, consistent with the enabled column added to the record type in November 2003.

Tables Accessed

The package operates against the following base objects via APPS synonyms:

• BIS_INDICATORS — The primary measure/indicator definition table, subject to insert, update, delete, and query operations.
• BIS_INDICATORS_TL — The translated-language companion table, written by the TRANSLATE_MEASURE routines.
• BIS_DIMENSIONS_TL — Read when resolving dimension-level translated content, particularly through RETRIEVE_MEASURE_DIMENSIONS.
• AK_REGION_ITEMS — Referenced for region and attribute metadata associated with measure definitions.
• FND_FORM_FUNCTIONS — Consulted to resolve function/security context, consistent with the region and application identifier attributes added to the record type in September 2004.

Usage Notes

BIS_MEASURE_PUB is referenced by twenty-seven other packages, indicating broad internal dependency across the Balanced Scorecard module and adjacent performance management components. It is typically invoked from the Measure Definer and related setup forms, from concurrent programs that load or synchronize measures across installed languages, and from custom extensions requiring programmatic measure maintenance. Because it is a PUB package, direct calls from custom code are supported, provided callers supply the documented record types — including the extended attributes for dataset identifier, region, source/compare application identifiers, WHO audit columns, and the enabled flag. The p_owner default parameter on CREATE_MEASURE and UPDATE_MEASURE, together with UPDT_PM_OWNER, provides the supported path for reassigning measure ownership without direct DML against BIS_INDICATORS.