Search Results bix_serlvl_alert

Overview

The APPS.BIX_ALERT package is a PL/SQL API classified under Oracle EBS as an OTHER object type, belonging to the BIX (Business Intelligence / Interaction Center telephony analytics) product family. Its declared header, compiled with AUTHID CURRENT_USER, exposes a small set of public alert procedures and one calculation function that operate against contact-center telephony metrics. The package serves as the programmatic layer used to evaluate threshold-based alerts for key performance indicators (KPIs) such as average answer time, service level, abandon rate, occupancy rate, average talk time, average wait time, utilization rate, and calls answered. Each alert procedure accepts a target-level short name, allowing alerts to be evaluated against organizational targets defined at a specific level within the resource hierarchy. The Calculate_Actual function provides the actual measured value for a given organization and time period, forming the numeric basis against which alert comparisons are made.

Key Procedures and Functions

The documented interface contains nine callable units. Eight are alert procedures, each taking a single target-level short name parameter that identifies the target grouping to evaluate:

• BIX_AVGANS_ALERT — evaluates the average answer time KPI against configured targets.
• BIX_SERLVL_ALERT — evaluates the service level KPI.
• BIX_ABANDON_ALERT — evaluates the call abandon rate KPI.
• BIX_OCCRATE_ALERT — evaluates the occupancy rate KPI.
• BIX_AVGTALK_ALERT — evaluates the average talk time KPI.
• BIX_AVGWAIT_ALERT — evaluates the average wait time KPI.
• BIX_UTLRATE_ALERT — evaluates the utilization rate KPI.
• BIX_CALLSANS_ALERT — evaluates the calls answered KPI.

The ninth callable unit is Calculate_Actual, a function (not a procedure) that returns a NUMBER. It accepts an organization identifier, a period set name, and a time period, and produces the actual measured value of the KPI for that organization and reporting window. Because it is a function, its result can be embedded directly in SQL or PL/SQL comparisons inside the alert procedures, making it the computational core of the package.

Tables Accessed

The metadata documents a single table reference accessed through APPS synonyms: BIX_SUM_GRP_CLS. This appears to be a summary/grouping classification table used to store or map the summarized telephony metric data that the alert procedures and the Calculate_Actual function read when determining actual values. The alert procedures likely join this summary data against target definitions keyed by the target-level short name to decide whether thresholds have been breached.

Usage Notes

The package carries a source header reference indicating an original build date of 2003 (BIXPALRS.pls, version 115.5), and the metadata records that it is referenced by zero other packages, meaning it is not a dependency of other documented PL/SQL APIs. In practice, such alert packages are typically invoked from concurrent programs, from Oracle Alert definitions, or from custom telephony dashboard code that schedules periodic KPI evaluation. When working in EBS 12.1.1 or 12.2.2, Calculate_Actual may be called directly from custom code to obtain an actual KPI value, while the eight alert procedures are normally driven by scheduled jobs. Because the package is compiled with AUTHID CURRENT_USER, invoker's rights apply, and the calling user must hold appropriate privileges on the underlying APPS synonyms such as BIX_SUM_GRP_CLS.