Search Results bix_alert




Overview
Explore in AI Chat

Overview

APPS.BIX_ALERT is a PL/SQL package body in the Oracle E-Business Suite APPS schema associated with the Oracle Business Intelligence System (BIS/BIX) family of products used for Enterprise Resource Planning analytics. Its status is VALID. The package provides the server-side computation and threshold-evaluation logic behind Oracle Alert functionality for call center and interaction-center performance indicators. In EBS 12.1.1 and 12.2.2, this package bridges the BIS foundation layer (targets, target levels, and indicators) with the alerting mechanism, allowing organizations to monitor contact center metrics and raise alerts when performance deviates from defined targets. ETRM classifies the package as API classification OTHER, indicating it is an internal rather than a formally published public API. The package body is documented with nine procedures and functions and is not referenced by any other database object, confirming its role as a top-level consumer of the BIS target and utility infrastructure rather than a shared library.

Key Procedures and Functions

The documented procedures and functions implement eight metric-specific alert evaluators plus a shared calculation routine. Each metric routine corresponds to a call center key performance indicator:

These procedures follow a common pattern: retrieve the actual value, compare it to the configured target level, and signal an alert condition through the BIS target and message infrastructure. Detailed parameter lists are not published in the ETRM metadata and should be verified in the live database before direct invocation.

Tables Accessed

The only table documented as referenced through an APPS synonym is BIX_SUM_GRP_CLS. This is a summary group classification table that stores the grouping and classification definitions used to organize contact center summary data, and it supplies the context needed by the alert routines to resolve which summary group or classification a given metric belongs to. The package also depends on views and public packages rather than base tables: BIX_CALL_CENTER_V (the call center analytics view supplying actual metric values), BISBV_TARGET_LEVELS and BISFV_TARGETS (target and target-level definitions), and the BIS public packages BIS_TARGET_PUB, BIS_TARGET_LEVEL_PUB, BIS_ACTUAL_PUB, BIS_POSTACTUAL, BIS_INDICATOR_REGION_PUB, and BIS_UTILITIES_PUB, along with BIS_UTIL. It further references FND_API and FND_MESSAGE for the standard API error-handling and message-resolution framework, and the SYS STANDARD package.

Usage Notes

BIX_ALERT is invoked indirectly rather than through direct customer calls. Typical invocation paths include the Oracle Alert Manager and BIS performance management flows, where metric thresholds must be checked and messages raised. Because the package is not referenced by any other database object, it is not part of a shared dependency chain; it is a leaf-level consumer. The package is commonly executed from concurrent programs, Oracle Alert periodic checks, or custom code that requires the same call center alert logic. The presence of FND_API and FND_MESSAGE dependencies means callers should expect standard EBS error-handling semantics, including API return status and message-stack behavior. As an OTHER-classified internal package, it carries no guaranteed upward compatibility, so customizations should call the documented procedures conservatively and validate signatures against the specific EBS point release (12.1.1 or 12.2.2) in use.