Search Results prepare_schema_instantiation

Overview

SYS.DBMS_CAPTURE_ADM is an Oracle-supplied PL/SQL package that provides the administrative interface for Oracle Streams capture processes. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack, this package is a foundational element of the database replication and change-data-capture infrastructure on which several EBS features depend, including Advanced Replication, Oracle Streams, and the underlying mechanisms used by EBS information discovery and data synchronization utilities. The package resides in the SYS schema and holds VALID status in the ETRM repository, confirming it is a supported and operational component of the certified EBS database configuration.

The package operates strictly at the database tier; it does not expose an EBS application-facing API and is not surfaced through Oracle Forms or concurrent programs in the standard EBS product set. Its importance lies in controlling the capture processes that mine redo and archive log data and convert that data into Logical Change Records (LCRs) for downstream propagation and apply operations.

Key Procedures and Functions

The ETRM documentation identifies 21 documented procedures and functions, classified under the generic API classification OTHER. The core capture administration routines are:

• CREATE_CAPTURE — Establishes a new capture process and associates it with a named Streams capture queue.
• ALTER_CAPTURE — Modifies the definition or attributes of an existing capture process.
• DROP_CAPTURE — Removes a capture process and its associated metadata.
• START_CAPTURE / STOP_CAPTURE — Control the execution state of a capture process.
• SET_PARAMETER — Adjusts tunable capture process parameters.

The instantiation-related routines prepare and clean up target schemas and databases for initial data transfer:

• PREPARE_SCHEMA_INSTANTIATION, PREPARE_GLOBAL_INSTANTIATION, ABORT_SCHEMA_INSTANTIATION, ABORT_GLOBAL_INSTANTIATION, and ABORT_TABLE_INSTANTIATION.

Synchronization and attribute routines include:

• CREATE_SYNC_CAPTURE, ALTER_SYNC_CAPTURE, ABORT_SYNC_INSTANTIATION, INCLUDE_EXTRA_ATTRIBUTE, and BUILD.

Tables Accessed

The ETRM metadata does not enumerate specific tables accessed via APPS synonyms for this package. As a SYS-owned Streams administrative package, DBMS_CAPTURE_ADM operates on the Streams data dictionary objects maintained in the SYS schema, including capture process definitions, rule sets, and queue metadata. In the EBS context, any capture definitions created for EBS schemas would reference the corresponding APPS or product schema objects as the source of captured changes, but the package itself does not directly query EBS application tables.

Usage Notes

DBMS_CAPTURE_ADM is referenced by twelve dependent packages, including DBMS_STREAMS_ADM_IVK, DBMS_STREAMS_AUTO_INT, DBMS_XSTREAM_ADM_UTL, and DBMS_LOGREP_IMP, indicating that EBS administrators and DBAs are far more likely to invoke the higher-level wrapper packages (DBMS_STREAMS_ADM, DBMS_XSTREAM_ADM) than to call DBMS_CAPTURE_ADM directly. Direct invocation is typically reserved for advanced replication configuration, custom change-data-capture implementations, and troubleshooting scenarios where a DBA requires granular control over a capture process. Because the package is owned by SYS and granted to PUBLIC, EXECUTE privileges are broadly available, but Oracle EBS operational guidance recommends restricting production use to controlled DBA change windows.