Search Results dbms_streams_adv_adm_utl_invok




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_ADV_ADM_UTL_INVOK is an Oracle-supplied, internal helper package that resides in the SYS schema and holds a status of VALID in both Oracle E-Business Suite 12.1.1 and 12.2.2 environments. Its name identifies it as a utility ("UTL") package belonging to the Streams Advanced Advisor administrative layer ("STREAMS_ADV_ADM"). The "INVOK" suffix indicates that the package exists to broker invocation logic for the Streams Advisor framework rather than to expose a public, user-callable API. In practical terms, it acts as a thin support layer beneath DBMS_STREAMS_ADVISOR_ADM, the Oracle package that captures and reports Streams Advisor statistics and advisories.

Because the Streams Advisor is part of the database feature set that Oracle EBS inherits from the underlying RDBMS, this object is not an EBS-authored component. It is present in the EBS database simply because the Streams option is installed in the Oracle home. It contains no seeded business logic and does not implement any EBS application-facing function such as subledger accounting, order capture, or concurrent processing.

Key Procedures and Functions

ETRM documents zero public procedures or functions for this package. The package specification is not published as a supported interface, and no parameter lists are recorded. What the metadata does establish is the dependency graph:

  • The package references SYS.STANDARD, confirming it is a conventional PL/SQL unit that builds on the base language package.
  • It is referenced by SYS.DBMS_STREAMS_ADVISOR_ADM, meaning the public Advisor administrative package calls into this utility internally.
  • It is also self-referenced, which is consistent with internal, recursive helper logic within the package body.

Because there are no documented entry points, customers should treat every routine inside the body as private and subject to change between RDBMS patch levels. No EBS code path should call it directly.

Tables Accessed

ETRM records no tables accessed through APPS synonyms for this object. This is the expected result: the Streams Advisor infrastructure reads and writes SYS-owned dictionary and persistent queue objects such as the DBA_STREAMS_* views and the Streams Advisor saved-run objects, none of which are exposed as EBS synonyms. Any such tables are therefore not listed as APPS-referenced dependencies.

Consequently, no EBS application tables are read or written by this package. It does not touch interfaces, staging, or transactional tables belonging to Financials, Supply Chain, or Manufacturing.

Usage Notes

The package is invoked only indirectly, when a DBA or an automated job calls DBMS_STREAMS_ADVISOR_ADM routines to run the Streams Advisor and gather recommendations. It is never called from an EBS form, concurrent program, or seeded workflow. In EBS 12.1.1 and 12.2.2, Streams is generally not configured for standard EBS replication topologies, which means this package is typically dormant.

Practical implications for EBS administrators and developers:

  • Do not invoke DBMS_STREAMS_ADV_ADM_UTL_INVOK from custom code; it is an unsupported internal unit.
  • Do not compile, drop, or modify it. It is owned by SYS and protected by the standard Oracle-supplied object rules.
  • If it appears in invalid-object reports after an RDBMS upgrade or an EBS patching cycle, recompile or resolve it only through utlrp.sql or Oracle Support guidance.
  • Its presence should not be treated as evidence that Streams replication is active in the EBS instance.

In summary, SYS.DBMS_STREAMS_ADV_ADM_UTL_INVOK is a valid but internal Streams Advisor utility in the EBS database. It has no documented procedures, no APPS-synonym table dependencies, and exactly one meaningful dependency relationship — being referenced by DBMS_STREAMS_ADVISOR_ADM — and should be left unmanaged by EBS practitioners.