Search Results dbms_streams_auto_int




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_AUTO_INT is an Oracle-supplied internal PL/SQL package that forms part of the Oracle Streams infrastructure delivered with the database kernel. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, its presence is not the result of any EBS-specific feature but rather of the underlying database release on which the application is certified. Oracle Streams provides a framework for capturing, propagating, and applying changes between database instances, and DBMS_STREAMS_AUTO_INT serves as an internal helper layer that orchestrates automated Streams configuration and administration tasks on behalf of the public, documented Streams APIs. Within EBS deployments — particularly those using Advanced Replication, Logical Standby, or Streams-based data propagation between primary and reporting instances — this package operates silently behind more visible entry points such as DBMS_CAPTURE_ADM and DBMS_PROPAGATION_INTERNAL. It is an unsupported, undocumented internal package; Oracle directs administrators and developers to the public DBMS_STREAMS, DBMS_CAPTURE_ADM, and DBMS_APPLY_ADM interfaces rather than calling this object directly.

Key Procedures and Functions

The ETRM documentation records this object as having zero documented procedures or functions. This is characteristic of _INT (internal) packages, whose entry points are deliberately withheld from public documentation and are subject to change without notice across database patch levels. The package body is present and valid, and it exposes callable units consumed exclusively by sibling internal packages. No parameter lists or signatures are documented, and no public API contract is offered. Practically, the procedures within this package perform automation logic — evaluating Streams configuration state, constructing and scheduling administrative actions, and returning results to the invoking internal callers. Because no supported surface exists, no procedure or function should be referenced from custom EBS code.

Tables Accessed

The supplied metadata does not enumerate tables referenced via APPS synonyms, and in practice no such references exist, since the package resides in the SYS schema and operates against Streams data dictionary views owned by SYS rather than EBS application tables. Any dictionary objects it reads are internal Streams metadata — capture, propagation, and apply configuration — and they are not exposed or documented for EBS-level querying.

Usage Notes

DBMS_STREAMS_AUTO_INT is never invoked from EBS forms, concurrent programs, or supported customization. According to the documented dependency graph, it is referenced by five packages: DBMS_CAPTURE_ADM, DBMS_CAPTURE_ADM_INTERNAL, DBMS_CAPTURE_ADM_IVK, DBMS_PROPAGATION_INTERNAL, and DBMS_STREAMS_SM (along with a self-reference). This dependency chain confirms its role as a shared internal utility beneath the capture-administration and propagation layers. It depends only on SYS.STANDARD, indicating a self-contained implementation with no reliance on EBS schemas. Administrators investigating Streams-related waits, invalid objects, or recompilation errors in an EBS database may encounter this package in dependency or invalidation reports; such occurrences should be resolved through standard database patching rather than manual recompilation or modification. Because Oracle may change internal package contents at any time, direct invocation risks breaking on patching and is not supported.