Search Results dbms_streams_adv_adm_utl




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_ADV_ADM_UTL is an Oracle-supplied PL/SQL package that forms part of the internal infrastructure supporting Oracle Streams and the Streams Advisor framework. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package operates as a low-level utility layer that is not intended for direct invocation by application developers or end users. Its role is to provide supporting logic to the broader Streams administrative and advisory APIs that Oracle Database exposes to EBS installations where Streams-based data replication, logical standby, or Advanced Replication configurations are deployed.

The package is owned by SYS and holds a VALID status within the E-Business Suite data dictionary. It sits below the public-facing Streams administration packages and above the core database kernel primitives, serving as a helper utility invoked by higher-level advisor and administrative routines. Because it is undocumented in the EBS API classification (classified as OTHER), it carries no supported external interface and must be treated as Oracle-proprietary internal machinery.

Key Procedures and Functions

The ETRM metadata documents zero externally documented procedures or functions for this package. This is consistent with its classification as an internal utility package. The package specification and body exist in the data dictionary, but Oracle does not publish a supported callable interface for it.

  • No documented public procedures or functions are exposed for customer or EBS application use.
  • The package body contains internal helper routines consumed exclusively by Oracle's Streams advisor administration stack.
  • Because no parameter lists are documented, no signature details can be reported, and developers should not attempt to call these routines directly.

Tables Accessed

The ETRM documentation does not list any tables referenced by SYS.DBMS_STREAMS_ADV_ADM_UTL through APPS synonyms. This reflects the fact that the package works against Oracle Streams dictionary objects and internal fixed views owned by SYS rather than against EBS application tables. In practice, packages of this class read and write Streams metadata repositories such as the Streams advisor tables and rule-set configuration data that underpin propagation, capture, and apply processes. None of these are exposed as EBS application schema objects.

Usage Notes

This package is not invoked from Oracle E-Business Suite forms, concurrent programs, or supported custom code. It is called indirectly at runtime by Oracle's own Streams administration and advisor components. The ETRM dependency listing confirms that SYS.DBMS_STREAMS_ADV_ADM_UTL is referenced by five other packages: DBMS_LOGREP_UTIL, DBMS_RECO_SCRIPT_INT, DBMS_STREAMS_ADM_IVK, DBMS_STREAMS_ADVISOR_ADM, and DBMS_STREAMS_ADV_ADM_UTL_INVOK. It in turn depends only on the STANDARD package and the SYS schema itself.

For EBS 12.1.1 and 12.2.2 administrators, the practical guidance is straightforward. The package should never be modified, recompiled manually, or called from custom PL/SQL. Its presence is a normal consequence of the Oracle Database release shipped with the EBS technology stack. If invalidation occurs, it is resolved by standard recompilation utilities such as utlrp.sql rather than by targeted intervention. Any troubleshooting involving this object should be escalated to Oracle Support, since its behavior is governed by Oracle-proprietary Streams logic outside the documented EBS API surface.