Search Results retrieve_measure_sec_sorted




Overview
Explore in AI Chat

Overview

BIS_MEASURE_SECURITY_PVT is a private PL/SQL API package within the Oracle E-Business Suite Applications (APPS) schema that governs security definitions applied to Performance Measurements in the Oracle Balanced Scorecard / Business Intelligence System (BIS) product family. Performance measurements are the quantified indicators an enterprise tracks against its strategic objectives; each measurement must be restricted to the appropriate set of users, responsibilities, or organizational target levels. This package provides the internal programmatic interface for creating, retrieving, updating, validating, and deleting those measurement-level and target-level security assignments.

The package is classified as a Private (PVT) API, meaning it is not intended for direct invocation by external consumers. It is declared AUTHID CURRENT_USER, so all SQL executed within it is resolved using the privileges of the calling session rather than the definer. The public counterpart, BIS_MEASURE_SECURITY_PUB, owns the record and table types (Measure_Security_Rec_Type, Measure_Security_Tbl_Type) that this package consumes and returns, establishing the standard EBS pattern of a thin public wrapper over a private implementation. The header history shows the package originated in November 1998 and that a procedure for deleting responsibilities at the target level was added in November 2003, reflecting the evolution of the scorecard security model.

Key Procedures and Functions

  • CREATE_MEASURE_SECURITY — creates a single measurement security assignment, with the security dimensions sequenced in the order in which they are passed. It accepts the standard API concurrency and commit parameters, a validation level defaulting to full validation, the security record itself, and an owner value defaulting to the custom owner defined in BIS_UTILITIES_PUB. It returns a standard return status and an error table.
  • RETRIEVE_MEASURE_SECURITIES — returns all performance measurement security assignments for a supplied target-level record, populating a security table type.
  • RETRIEVE_MEASURE_SEC_SORTED — a variant of the retrieval procedure that returns measurement security information in a sorted order, added in September 2000.
  • RETRIEVE_MEASURE_SECURITY — retrieves a single measurement security definition rather than a set.
  • UPDATE_MEASURE_SECURITY — modifies an existing measurement security assignment.
  • DELETE_MEASURE_SECURITY — removes an existing measurement security assignment. This is the procedure most commonly searched for under the name "delete_measure_security," and it is the API responsible for revoking a security grant on a performance measurement.
  • VALIDATE_MEASURE_SECURITY — performs the validation logic used by the create and update paths, checking the supplied security record against the business rules that constrain valid assignments.
  • VALUE_ID_CONVERSION — a helper routine that converts an internal value identifier into the corresponding security value representation.
  • RETRIEVE_TAR_LEVEL_USER_RESPS — retrieves the responsibilities associated with users at a given target level.
  • DELETE_TARGETLEVEL_RESP — deletes responsibility assignments at the target level, added in November 2003 to support bulk removal of security at the target level rather than the individual measurement level.

Tables Accessed

The package reads and writes the core Balanced Scorecard security tables through APPS synonyms. BIS_INDICATORS holds the performance measurement (indicator) definitions to which security is applied. BIS_INDICATOR_RESPS and its intersection table BIS_INDICATOR_RESPS_S store the responsibility-level assignments that grant access to individual indicators; these are the primary targets of the create, update, delete, and retrieval procedures. BIS_TARGET_LEVELS supplies the target-level hierarchy used to scope security down to a particular organizational level, and is the table underlying the target-level retrieval and deletion routines. DUAL is used for trivial single-row evaluations, and PLITBLM is the PL/SQL index-by table of VARCHAR2 used internally to stage lists of values during processing.

Usage Notes

Because BIS_MEASURE_SECURITY_PVT is a private API, it should not be called directly from custom code or from a standalone script. In Oracle EBS 12.1.1 and 12.2.2 the appropriate integration point is the public package BIS_MEASURE_SECURITY_PUB, which exposes the supported entry points and the associated record and table types. The private package is invoked internally through that wrapper layer, for example when a user maintains measurement security from the Balanced Scorecard administrative forms in the BIS application. The procedures may also be driven by concurrent programs or internal product code that provisions, copies, or removes scorecard security assignments, particularly the target-level responsibilities managed by RETRIEVE_TAR_LEVEL_USER_RESPS and DELETE_TARGETLEVEL_RESP.

Callers invoking the create, update, or delete paths should respect the standard EBS API conventions: pass an accurate API version, control transaction boundaries through the commit flag rather than issuing independent commits, and inspect the returned status and error table before proceeding. Because the package executes with the privileges of the caller, the invoking session must have the necessary grants on the underlying BIS tables. The package header indicates a last shipped version of 115.26 (December 2003), so behavior and available procedures are consistent across the 12.1.1 and 12.2.2 releases unless a later patch level of the file has been applied.