Search Results dbms_capture_process




Overview
Explore in AI Chat

Overview

SYS.DBMS_CAPTURE_PROCESS is an Oracle-supplied database package that forms part of the underlying Streams / LogMiner capture infrastructure shipped with the Oracle RDBMS. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, it is catalogued in ETRM with owner SYS, object type PACKAGE, and status VALID. Its API classification within ETRM is recorded as OTHER, indicating that it is not an EBS application-facing interface but rather an internal database kernel component.

Within EBS, DBMS_CAPTURE_PROCESS supports the change data capture and propagation mechanisms that Oracle Streams uses to capture DML changes from redo/archive logs. This is relevant to EBS operational topologies that rely on Streams-based replication, logical standby, or downstream data propagation from the primary EBS database to reporting or integration instances. It does not implement any EBS business logic; its function is confined to managing the capture process life cycle at the database tier.

Key Procedures and Functions

The ETRM documentation for this object records zero documented exposed procedures or functions. The dependency extract lists only SYS.STANDARD, the implicit PL/SQL standard package that every compiled unit references, and does not enumerate a procedural surface. Consequently, no callable procedure or function can be described based on documented facts, and parameter lists must not be assumed.

  • No published procedure or function signatures are recorded in the ETRM metadata for this package.
  • The absence of entries reflects that the package is an internal, kernel-level unit rather than a documented public API.
  • Functionality associated with capture process management is exposed to administrators through the supported DBMS_CAPTURE_ADM and DBMS_STREAMS_ADM interfaces rather than by invoking DBMS_CAPTURE_PROCESS directly.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. This is consistent with its role as a SYS-owned internal component: any persistent state it touches resides in database-managed Streams and LogMiner dictionary objects within the SYS schema, such as capture process definition and runtime metadata, rather than in EBS application tables registered under the APPS schema. No EBS transactional or setup tables are read or written by this package.

Usage Notes

DBMS_CAPTURE_PROCESS is not invoked by Oracle E-Business Suite forms, concurrent programs, or application PL/SQL. ETRM reports that it is referenced by zero other packages, confirming that it is not a dependency of any documented EBS or database PL/SQL unit in the extracted dependency graph.

  • Invocation occurs implicitly through the Oracle database kernel and Streams capture framework; it is not called from EBS application code.
  • Database administrators managing Streams-based EBS replication should use the supported administrative packages (DBMS_CAPTURE_ADM, DBMS_STREAMS_ADM) instead of addressing this package directly.
  • Because it is a SYS-owned, Oracle-proprietary component, it must not be modified, wrapped, or called from custom code; any such usage is unsupported.
  • Customizations should treat this object as read-only infrastructure metadata. Where Streams are configured for an EBS instance, its presence and VALID status should be verified after database upgrades or patches that affect the capture stack.