Search Results dbms_logrep_util_invok

Overview

SYS.DBMS_LOGREP_UTIL_INVOK is an internal Oracle-supplied PL/SQL package that forms part of the infrastructure supporting Oracle Streams, Advanced Queuing-based replication, and the LogMiner-based capture and apply engines. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package is not an application-level API; it is a database-tier utility that resides in the SYS schema and carries a VALID status. Its role is to provide an invocation wrapper layer through which higher-level replication administration packages call underlying LogMiner and log representation utilities. The ETRM metadata classifies the object under the "OTHER" API classification, confirming that it is not exposed as a documented EBS business API but rather as an internal dependency of the replication stack.

Key Procedures and Functions

The documented ETRM metadata for this package lists zero publicly documented procedures or functions. This is consistent with its status as an internal helper package: the callable units are intended for consumption by other SYS-owned packages rather than by application developers or EBS customization code. Accordingly, no parameter lists are documented and none should be assumed. The package body is exposed only through the standard - show dependent code affordance in the dependency report, indicating that its logic is visible for diagnostic purposes but not published as a supported interface.

Tables Accessed

No tables are documented as being referenced through APPS synonyms for this package. This is expected given that DBMS_LOGREP_UTIL_INVOK is a SYS-level replication utility. Where it does touch data, it operates on the underlying Streams and LogMiner dictionary views and internal fixed tables rather than on EBS application tables. Because the ETRM dependency extract enumerates only the package-to-package relationships, no direct table dependencies are surfaced. Administrators should therefore treat the package as a kernel-level object whose data access is mediated entirely by the SYS packages that invoke it.

Usage Notes

The dependency information establishes the practical invocation paths. DBMS_LOGREP_UTIL_INVOK references STANDARD (the PL/SQL base package) and is itself referenced by a well-defined set of eight packages, including DBMS_APPLY_ADM, DBMS_APPLY_ADM_IVK, DBMS_CAPTURE_ADM, DBMS_CAPTURE_ADM_INTERNAL, DBMS_CAPTURE_ADM_IVK, DBMS_RECO_SCRIPT_INVOK, DBMS_STREAMS_ADM_UTL_INVOK, and DBMS_XSTREAM_UTL_IVK. A self-reference (DBMS_LOGREP_UTIL_INVOK) also appears, indicating recursive internal calls.

Custom code should never call DBMS_LOGREP_UTIL_INVOK directly; supported entry points are the administrative packages such as DBMS_CAPTURE_ADM and DBMS_APPLY_ADM.
The package is activated implicitly whenever capture or apply processes are configured or invoked in a Streams or XStream topology.
Its presence in the EBS database is a consequence of the Oracle Database release rather than of EBS patch level; both 12.1.1 and 12.2.2 inherit it from the underlying RDBMS.
For troubleshooting, dependency tracing should start from the calling administrative package, since the invocation wrapper offers no documented diagnostic interface of its own.
Any invalidation of this package cascades to the eight dependent packages, so recompilation after database upgrades should be verified as part of standard SYS object validation checks.

In summary, DBMS_LOGREP_UTIL_INVOK is a foundational but unsupported internal package whose significance in an EBS environment lies in the health of the replication packages that depend upon it.

PACKAGE: SYS.DBMS_LOGREP_UTIL_INVOK 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL_INVOK 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL_INVOK 12.2.2
PACKAGE BODY: SYS.DBMS_CAPTURE_ADM_IVK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_ADM_IVK, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL_INVOK 12.1.1
PACKAGE: SYS.DBMS_LOGREP_UTIL_INVOK 12.2.2
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL_INVOK 12.1.1
PACKAGE BODY: SYS.DBMS_STREAMS_ADM_UTL_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM_UTL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM_IVK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_ADM_IVK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_ADM_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM_IVK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_ADM, status:VALID,
PACKAGE: SYS.DBMS_STREAMS_ADM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_ADM, status:VALID,
LIBRARY: SYS.DBMS_LOGREP_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_LOGREP_LIB, status:VALID,
LIBRARY: SYS.DBMS_LOGREP_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_LOGREP_LIB, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_UTL_IVK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_UTL_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_UTL_IVK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_UTL_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_ADM_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_ADM_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_PRIV_CAPTURE 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_PRIV_CAPTURE, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_ADM_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_ADM_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_STREAMS_ADM 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_ADM, status:VALID,
PACKAGE: SYS.DBMS_PRIV_CAPTURE 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_PRIV_CAPTURE, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADM_UTL_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM_UTL_INVOK, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.DBMS_UTILITY 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_UTILITY, status:VALID,
SYS.DBMS_CAPTURE_ADM_IVK dependencies on DBMS_LOGREP_UTIL_INVOK 12.1.1
PACKAGE: SYS.DBMS_UTILITY 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_UTILITY, status:VALID,
SYS.DBMS_CAPTURE_ADM_INTERNAL dependencies on DBMS_LOGREP_UTIL_INVOK 12.1.1
SYS.DBMS_XSTREAM_UTL_IVK dependencies on DBMS_LOGREP_UTIL_INVOK 12.2.2
SYS.DBMS_STREAMS_ADM_UTL_INVOK dependencies on DBMS_LOGREP_UTIL_INVOK 12.2.2
SYS.DBMS_APPLY_ADM_IVK dependencies on DBMS_LOGREP_UTIL_INVOK 12.1.1
SYS.DBMS_LOGREP_UTIL_INVOK dependencies on DBMS_LOGREP_UTIL_INVOK 12.1.1
SYS.DBMS_RECO_SCRIPT_INVOK dependencies on DBMS_LOGREP_UTIL_INVOK 12.1.1
SYS.DBMS_LOGREP_UTIL_INVOK dependencies on DBMS_LOGREP_UTIL_INVOK 12.2.2
SYS.DBMS_APPLY_ADM dependencies on DBMS_LOGREP_UTIL_INVOK 12.2.2
SYS.DBMS_CAPTURE_ADM dependencies on DBMS_LOGREP_UTIL_INVOK 12.1.1
SYS.DBMS_CAPTURE_ADM dependencies on DBMS_LOGREP_UTIL_INVOK 12.2.2
SYS.DBMS_APPLY_ADM dependencies on DBMS_LOGREP_UTIL_INVOK 12.1.1