Search Results dbms_prvtsqis




Overview
Explore in AI Chat

Overview

SYS.DBMS_PRVTSQIS is an Oracle-supplied, internal PL/SQL package that forms part of the Advanced Queuing (AQ) infrastructure shipped with the database kernel. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is one of a family of private ("PRVT") packages that implement the server-side logic behind the public DBMS_AQ, DBMS_AQADM, and DBMS_AQADM_SYS interfaces. It is owned by SYS, carries a VALID status, and is documented in the ETRM repository with an API classification of OTHER, reflecting its role as a supporting internal component rather than a callable application programming interface.

The "TSQIS" portion of the name is consistent with the internal naming convention used for time-series and queue integration support routines within the AQ stack. DBMS_PRVTSQIS therefore exists to encapsulate queue-related processing that would otherwise clutter the public AQ entry points, ensuring that only validated operations are exposed to application code. Because it is a private package, it is not part of Oracle's supported public API and is not intended for direct invocation.

Key Procedures and Functions

The ETRM metadata records zero documented procedures or functions for this package. This is typical of private AQ packages: their subprograms are considered implementation details and are therefore excluded from the public documentation set. No parameter lists, return types, or signatures can be confirmed from the available metadata, and none are asserted here. What can be established from the dependency information is that the package exposes callable units consumed internally by its parent and sibling packages, principally DBMS_AQADM_SYS and DBMS_PRVTAQIS.

Tables Accessed

The documented dependency list identifies SYS.AQ$_AGENT as a referenced object. AQ$_AGENT is the base dictionary table that stores agent definitions—the named producers and consumers, including their addresses and protocol settings—used throughout the Advanced Queuing model. DBMS_PRVTSQIS can therefore be understood to read and manipulate agent metadata as part of resolving queue participants during internal queue operations.

In addition to AQ$_AGENT, the package depends on DBMS_AQADM_SYS and STANDARD. DBMS_AQADM_SYS is the private administrative engine for AQ and supplies the lower-level queue administration primitives. STANDARD provides the core PL/SQL runtime environment. No APPS-synonym tables are documented as being accessed by this package, which is consistent with a kernel-level component operating wholly within the SYS schema on AQ dictionary objects rather than on E-Business Suite application tables.

Usage Notes

DBMS_PRVTSQIS is not invoked directly by Oracle EBS forms, concurrent programs, or customer-written code. It is reachable only through the AQ call stack: the dependency listing shows that DBMS_PRVTSQIS is referenced by DBMS_AQADM_SYS, DBMS_PRVTAQIS, and by itself, and that it in turn references DBMS_AQADM_SYS. Application and middleware code interacts with this functionality indirectly whenever it calls the public DBMS_AQ or DBMS_AQADM interfaces, or when EBS components such as Workflow Mailer, Oracle Alert, or the Business Event System enqueue and dequeue messages.

  • Do not grant EXECUTE on this package or reference it from custom code; doing so bypasses supported AQ entry points and risks invalidating Oracle's certification of the EBS database tier.
  • The package appears in dependency and invalidation reports for the AQ schema. Its VALID status should be verified after database upgrades, since an invalid DBMS_PRVTSQIS can cascade to DBMS_AQADM_SYS and disrupt queue administration.
  • Because the object is owned by SYS and classified as OTHER in ETRM, it is treated as a fixed kernel object in EBS 12.1.1 and 12.2.2; it must not be modified, recompiled manually, or renamed.