Search Results dbms_capture_adm_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_CAPTURE_ADM_INTERNAL is an Oracle-supplied internal PL/SQL package that forms part of the Oracle Streams and XStream replication infrastructure. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package supports the administrative layer that governs capture processes — the mechanisms responsible for mining redo log records and enqueueing logical change records (LCRs) into a queue for downstream propagation and apply. The package resides in the SYS schema and is classified as OTHER under the ETRM API classification scheme, reflecting its role as a private implementation dependency rather than a published, customer-facing API.

The object is reported with a status of VALID, confirming that it is compiled and operational within the database. Its primary significance in an EBS environment is architectural: it is the internal workhorse that the documented public interfaces — DBMS_CAPTURE_ADM, DBMS_STREAMS_ADM, and the XStream administration packages — delegate to when capture rules, capture processes, and associated metadata are created, altered, or dropped. Because EBS leverages Streams-based technology for certain data replication, advanced queuing, and change-data-capture scenarios, the integrity of this package directly affects the reliability of those subsystems.

Key Procedures and Functions

The ETRM metadata for this object documents zero public procedures and functions. This is consistent with its classification as an internal implementation package: its callable units are not exposed for direct customer invocation and are intentionally undocumented at the API level. No parameter lists are published, and none should be assumed.

Functionally, the package provides the internal administrative primitives consumed by higher-level packages. Its scope includes support for capture process lifecycle operations — creation, modification, startup, and shutdown of capture processes — as well as the management of capture-related metadata such as rulesets, rule evaluations, and queue associations. These operations are surfaced to DBAs and applications exclusively through the documented public wrappers rather than through DBMS_CAPTURE_ADM_INTERNAL itself.

Tables Accessed

The ETRM documentation does not enumerate any tables referenced via APPS synonyms for this package. This is expected: as a SYS-owned dictionary-level component, it operates against Streams and LogMiner repository objects and internal fixed tables rather than against EBS application schema tables. Any data dictionary views and Streams metadata tables it touches are accessed under SYS privileges and are not surfaced through the APPS synonym layer. Customers should therefore not expect this package to read or write EBS transactional or setup tables directly.

Usage Notes

DBMS_CAPTURE_ADM_INTERNAL is never invoked directly from Oracle Forms, concurrent programs, or supported custom code within EBS. It is reached only through supported public packages, as evidenced by its dependency graph. It references DBMS_UTILITY and STANDARD, and it is referenced by twelve other packages, including DBMS_CAPTURE_ADM, DBMS_APPLY_ADM_INTERNAL, DBMS_CAPTURE_PROCESS, DBMS_LOGREP_IMP, DBMS_STREAMS_ADM_IVK, DBMS_STREAMS_ADM_UTL, DBMS_STREAMS_MT, and DBMS_XSTREAM_ADM_UTL, among others.

Two practical consequences follow. First, any tuning or troubleshooting of Streams capture behavior in EBS should target the documented public packages, not this internal object. Second, because the package participates in a dense dependency web, invalidating or recompiling it may cascade to dependent packages; DBAs should treat it as a protected SYS component and avoid manual recompilation unless directed by Oracle Support. Its presence and VALID status are best verified through standard dictionary queries when diagnosing Streams or XStream failures in an EBS 12.1.1 or 12.2.2 environment.