Search Results bis_alert_service_pub




Overview
Explore in AI Chat

Overview

BIS_ALERT_SERVICE_PUB is a public PL/SQL package in the APPS schema that forms part of the Oracle E-Business Suite Business Intelligence System (BIS) alerting framework. Its principal business function is to accept alert requests raised within EBS and route them to the underlying alert delivery infrastructure. Rather than implementing notification logic itself, the package acts as a service façade, delegating the mechanics of alert processing to internal BIS private packages. In this way it provides a stable, supported entry point for submitting alert requests from forms, concurrent programs, and custom code, insulating callers from changes in the private implementation.

Key Procedures and Functions

The ETRM documentation for this package records a single public procedure:

  • SERVICE_ALERT_REQUEST — the documented public entry point for submitting an alert request. Based on its name and the package's dependency graph, this procedure accepts an alert request and passes it into the alert service pipeline for evaluation and dispatch. It should be treated as the supported calling interface; the ETRM metadata does not document its parameter list, and callers should use the signature declared in the database rather than assuming any particular argument sequence.

No other public procedures or functions are documented in the ETRM extract. Any additional logic resides in the package body and is not part of the published contract.

Tables Accessed

The ETRM metadata does not identify any tables referenced through APPS synonyms, and no direct SQL table access is documented. Instead, the package depends on the following PL/SQL components, which carry out the actual data operations:

  • BIS_CONCURRENT_MANAGER_PVT — the private concurrent manager layer that handles submission and management of alert-related concurrent processing.
  • BIS_PMF_REG_SERVICE_PVT — the private registration service layer associated with the BIS Performance Management Framework, responsible for resolving and servicing registered alert definitions.
  • SYS.STANDARD — the standard Oracle built-in package, reflecting normal PL/SQL runtime usage.

Any persistent reads or writes to BIS configuration and alert tables therefore occur indirectly through these dependent packages rather than from BIS_ALERT_SERVICE_PUB itself.

Usage Notes

BIS_ALERT_SERVICE_PUB is classified as a PUB (public) API, indicating that it is intended for supported invocation rather than internal-only use. It is typically called when an application or concurrent program needs to raise an alert request and hand it to the BIS alerting framework for processing. Consistent with EBS practice, such service packages are commonly invoked from concurrent programs, from Oracle Forms business logic through server-side PL/SQL, or from custom extensions that require alert submission.

The dependency listing shows the package referencing itself and no other package referencing it within the documented scope, so it should be treated as a top-level service interface rather than a shared utility. Because the ETRM documentation records only one procedure and no parameter details, developers should query ALL_ARGUMENTS or inspect the package specification in their specific environment before coding calls. The package is reported as VALID in both the 12.1.1 and 12.2.2 ETRM repositories, and its behavior is expected to be consistent across those releases.