Search Results bis_measure_security_pvt




Overview
Explore in AI Chat

Overview

The APPS.BIS_MEASURE_SECURITY_PUB package is a public application programming interface within the Oracle E-Business Suite Business Intelligence System (BIS) module, now commonly surfaced through the Oracle Enterprise Performance Management (EPM) and Enterprise Resource Planning (ERP) integrations delivered under the ETRM umbrella. Its principal business function is to manage measure-level security definitions — the rules that determine which users, responsibilities, or roles are authorized to view or manipulate specific measures, key performance indicators, and scorecard targets defined in the BIS performance management framework. By centralizing the creation, retrieval, modification, validation, and deletion of measure security assignments behind a published PL/SQL API, the package ensures that access control logic is applied consistently across the scorecard, dashboard, and target-setting components of the application.

Because it is classified as a PUB (public) API and resides in the APPS schema, BIS_MEASURE_SECURITY_PUB is intended to be the supported entry point for external or custom callers. Internal implementation detail is delegated to the companion private package BIS_MEASURE_SECURITY_PVT, which is the object most frequently returned in searches for bis_measure_security_pvt. The PUB wrapper insulates callers from changes to that private layer.

Key Procedures and Functions

The ETRM documentation records eight procedures and functions in this package. Their documented purposes are as follows:

  • CREATE_MEASURE_SECURITY — Establishes a new security assignment linking a measure to a grantee, defining the access privilege that grantee holds over that measure.
  • RETRIEVE_MEASURE_SECURITIES — Returns the full set of measure security records, typically used to populate administrative lists or reporting views.
  • RETRIEVE_MEASURE_SECURITY — Retrieves a single, specific measure security definition, generally by its identifying key.
  • UPDATE_MEASURE_SECURITY — Modifies an existing measure security assignment, such as changing the granted access level.
  • DELETE_MEASURE_SECURITY — Removes a measure security assignment, revoking the associated access.
  • VALIDATE_MEASURE_SECURITY — Performs integrity and business-rule checks on a proposed security definition before it is persisted.
  • DELETE_TARGETLEVEL_RESP — Removes responsibility-level target associations, supporting cleanup when a responsibility is reassigned or retired.

Parameter signatures are not reproduced here, as the documented metadata does not enumerate them.

Tables Accessed

The ETRM extract for this object does not list specific base tables; references are made through APPS synonyms. In practice, this package and its private counterpart operate against the BIS measure security and target-level responsibility tables that store the mapping between measures, responsibilities, and access privileges. The absence of an explicit table list in the metadata means integrators should inspect the package body via USER_SOURCE or the ETRM "show dependent code" link to confirm exact table dependencies before extending the API.

Usage Notes

BIS_MEASURE_SECURITY_PUB is referenced by four other packages — including BIS_MEASURE_SECURITY_PVT, BIS_MEASURE_SEC_VALIDATE_PVT, BIS_PMF_DEFINER_WRAPPER_PVT, and BIS_TARGET_PVT — and it in turn depends on BIS_TARGET_LEVEL_PUB, BIS_UTILITIES_PUB, and FND_API. It is typically invoked from the BIS administrative setup forms, from concurrent programs that batch-load or refresh security definitions, and from custom code that needs to provision measure access programmatically. Because it consumes FND_API, callers should expect standard EBS API conventions such as FND_API.G_MISS_* handling and x_return_status/x_msg_count/x_msg_data output parameters, and should always check the return status before committing.