Search Results gl_bis_alerts_pkg




Overview
Explore in AI Chat

Overview

APPS.GL_BIS_ALERTS_PKG is a PL/SQL package in the Oracle E-Business Suite General Ledger (GL) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. The package name embeds the BIS (Business Intelligence System) and ALERTS tokens, indicating that its business purpose is to support the delivery of General Ledger alert and notification logic within the Oracle EBS reporting and intelligence framework. Alerts in this context are typically condition-driven messages or signals evaluated against GL data so that end users or administrators are made aware of exceptions, thresholds, or state changes requiring attention.

The ETRM record classifies the package API as OTHER, and the source excerpt shows a stub-style specification: the package body opens, a header comment records its purpose ("To create GL_BIS_ALERTS_PKG package"), a history line identifies the original creation date of 28-MAY-99 by K Vora, and the specification ends immediately at line 14. The current $Header identifies version 120.4 dated 2012/01/25. This indicates an object that has been retained for upgrade and backward-compatibility purposes rather than one that exposes a rich public interface in the current release.

Key Procedures and Functions

The documented metadata for this package lists zero procedures or functions. The specification as shipped contains no public procedure or function declarations between the package opening and its terminating END GL_BIS_ALERTS_PKG; statement. Consequently, there are no published entry points that a caller can invoke in the 12.2.2 code line represented by this ETRM record.

Because no callable units are documented, no parameter lists, return types, or processing contracts can be stated. Any historical alert-generation logic that may once have existed is either encapsulated in private helpers, superseded by successor objects, or deprecated. Consumers must not assume the presence of any named routine within this package.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms by this package. Consistent with a specification containing no DML-bearing routines, the object as documented does not read from or write to any General Ledger base tables, GL interface tables, or alert configuration tables. Specifically, no access to GL_JE_HEADERS, GL_JE_LINES, GL_BALANCES, or any FND alert framework tables is documented. Because there is no declared data access surface, the package cannot be relied upon to persist, query, or transform ledger data in its current form.

Usage Notes

The package is referenced by zero other packages according to the documented dependency metadata, which strongly suggests it is not an active dependency in current GL processing. It is not invoked by any documented form, concurrent program, or standard workflow call. Custom code that previously called this package should be reviewed against the current release level, since no procedures or functions are available to invoke. The retained specification appears to exist for upgrade integrity and to preserve the object namespace; developers performing 12.1.1 to 12.2.2 migrations should treat it as a deprecated placeholder. Any requirement for General Ledger alerting or BIS-driven notifications in a current implementation should be satisfied through the supported Oracle Alerts (ALR) and Business Intelligence framework components rather than through this package.