Search Results que_int




Overview
Explore in AI Chat

Overview

KUPC$QUE_INT is an internal PL/SQL package owned by the SYS schema and shipped as part of the Oracle Database kernel components that Oracle E-Business Suite 12.1.1 and 12.2.2 rely upon. Its name follows Oracle's convention for internal, undocumented ("$") packages: the leading KUPC prefix identifies it as a component of the Oracle Streams / Advanced Queueing change-capture and propagation infrastructure, while the suffix QUE_INT denotes a queue interface. In the EBS context, this package provides the low-level interface between the change-capture queue and the apply process, allowing captured database change records to be enqueued, dequeued, and managed on behalf of higher-level EBS components.

Within EBS, the package underpins features that depend on database-level capture of DML activity, such as Oracle Advanced Queuing and the subset of EBS modules that publish or consume messages. Its status is VALID in the documented environment, confirming the compiled object is present and usable. The package is classified as OTHER rather than as a supported public API, which indicates it is an internal implementation object and not intended for direct invocation by developers or end users.

Key Procedures and Functions

The documented ETRM metadata records no public procedures or functions for this package. This is consistent with its role as an internal wrapper, where callable entry points are either hidden or not exposed for external use. Consequently, no parameter lists can be published; any caller interface is private to the kernel implementation.

The dependency list confirms the package's runtime collaborators. KUPC$QUE_INT references SYS.KUPC$QUEUE, the underlying queue object that stores captured messages, and SYS.KUPC$_MESSAGE, the message structure used to represent individual change records. It also depends on STANDARD, the built-in PL/SQL package that supplies fundamental language constructs and exceptions, which every stored program unit references implicitly.

Tables Accessed

No application tables referenced through APPS synonyms are documented for this package. The only data structures identified in the metadata are the internal queue components KUPC$QUEUE and KUPC$_MESSAGE. KUPC$QUEUE holds the pending change records that the interface manages, and KUPC$_MESSAGE provides the message payload definition applied when enqueuing and dequeuing those records. Because these are SYS-owned kernel objects, they are not exposed through the EBS application schema and should not be queried or modified for business reporting.

Usage Notes

KUPC$QUE_INT is invoked indirectly by the database change-capture and queue subsystem rather than from EBS forms, concurrent programs, or report definitions. The reverse-dependency metadata shows that it is referenced by one other package, SYS.KUPC$QUEUE_INT, which acts as its external-facing counterpart within the same internal family, and it recursively references itself. This layered arrangement allows the queue interface to be reused without exposing the underlying message mechanics.

Practitioners should treat this package as read-only infrastructure. Custom code, concurrent programs, and forms must never call KUPC$QUE_INT directly, since Oracle does not document or support its interface and its signature may change between database releases or EBS patch levels. The package becomes relevant to EBS administrators only when diagnosing queue or change-capture errors, where its VALID status and dependency chain help confirm that the internal Streams/AQ plumbing is intact. Oracle's proprietary and confidentiality notices reinforce that the object is internal and subject to change without notice.