Search Results hr_bis_alerts




Overview
Explore in AI Chat

Overview

The APPS.HR_BIS_ALERTS package is a PL/SQL database object in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases. It resides in the APPS schema and holds a VALID status, indicating that the package specification and body compile successfully against the standard EBS data model. The package is classified in the ETRM metadata under the API classification "OTHER," meaning it is not a public, supported open interface or business API, but rather an internal component whose primary consumer is the HR Business Intelligence System (BIS) functional area.

Functionally, HR_BIS_ALERTS supports the Human Resources intelligence layer by evaluating indicator and target data and surfacing alert-related logic tied to workforce metrics. It bridges the BIS indicator/target tables with HR and Oracle Training Administration (OTA) transactional data, and it interacts with the Oracle Alert/Message framework to generate notifications. In short, it provides the procedural machinery that determines when a business target or indicator threshold has been breached and posts the corresponding actual values, optionally emitting a message to the appropriate responsibility or user.

Key Procedures and Functions

The ETRM documentation for this package lists two documented program units:

  • CALC_AND_POST_TARGET_ACTUALS — Calculates the current actual value associated with a defined BIS target and posts that actual value to the relevant target/indicator storage. It represents the core computation step that reconciles planned targets against realized data drawn from HR and OTA sources.
  • PROCESS_TARGET — Drives target processing for an indicator, evaluating the stored target against the calculated actual and determining whether an alert condition exists. It is the orchestration entry point that ties calculation, comparison, and alert generation together.

No parameter lists are reproduced here because the ETRM excerpt does not document signatures; parameter details should be confirmed directly in the database source via the procedural "show dependent code" facility.

Tables Accessed

The package references the following application tables through APPS synonyms. The BIS-specific tables — BIS_INDICATORS and BIS_TARGET_VALUES — define the metrics being monitored and their target thresholds. HR organizational context comes from HR_ALL_ORGANIZATION_UNITS, PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES, and the budget tables PER_BUDGET_ELEMENTS, PER_BUDGET_VALUES, and PER_BUDGET_VERSIONS. Training-related activity is sourced from OTA_EVENTS, OTA_ACTIVITY_VERSIONS, OTA_BOOKING_STATUS_TYPES, and OTA_DELEGATE_BOOKINGS. Alert and message infrastructure is provided by FND_NEW_MESSAGES and FND_RESPONSIBILITY, while FF_FORMULAS_F supplies Fast Formula definitions used in derived calculations.

Usage Notes

According to the documented dependency graph, HR_BIS_ALERTS is referenced by no other packages, and it references only STANDARD (the PL/SQL environment). This self-contained profile suggests it is invoked directly rather than as a subordinate module — typically from concurrent programs, scheduled target-processing jobs, or Oracle HRMS BIS/Alert configuration flows that evaluate workforce and training indicators. Because it is classified as "OTHER" and is not a supported public API, custom code should not call it as a stable interface; instead, integrations should rely on supported HRMS APIs, and any direct invocation should be validated against the target EBS patch level (12.1.1 or 12.2.2), since internal package logic may change between releases.