Search Results compare_old_values

Overview

SYS.DBMS_APPLY_ADM is an Oracle-supplied PL/SQL package that forms part of the Oracle Streams and Change Data Capture infrastructure shipped with the database tier underlying Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to administer apply processes, which are the components that consume captured logical change records from a queue and apply the corresponding DML and DDL operations to a destination database or schema. In an EBS context, this functionality supports near-real-time propagation of transactional data between environments, reporting instances, and data warehouses, and underpins logical standby and advanced replication topologies.

The package is owned by SYS and is exposed to the EBS APPLICATIONS schema through a public synonym. The ETRM metadata classifies the API as OTHER, meaning it is not an EBS business API in the sense of an Oracle Application Object Library interface, but a database-supplied utility invoked by the Streams framework itself and by the higher-level DBMS_STREAMS_ADM and DBMS_XSTREAM_ADM packages.

Key Procedures and Functions

The documented interface exposes 36 procedures and functions. The most significant groups are:

• Process lifecycle: CREATE_APPLY, ALTER_APPLY, DROP_APPLY, START_APPLY and STOP_APPLY create, modify, remove, start and stop an apply process. These are the core administrative entry points used to define and control the consumer of a queue.
• Error management: GET_ERROR_MESSAGE, DELETE_ERROR, DELETE_ALL_ERRORS, EXECUTE_ERROR and EXECUTE_ALL_ERRORS retrieve, purge and re-execute transactions that failed during apply. These are essential for reconciliation after a destination-side failure.
• Instantiation control: SET_TABLE_INSTANTIATION_SCN, SET_SCHEMA_INSTANTIATION_SCN and SET_GLOBAL_INSTANTIATION_SCN establish the system change number from which a table, schema or entire database should begin applying changes.
• Conflict handling: SET_UPDATE_CONFLICT_HANDLER, SET_DML_HANDLER and COMPARE_OLD_VALUES configure how update conflicts are resolved and how conditional old-value comparisons are performed.
• Key and parameter configuration: SET_KEY_COLUMNS defines the primary key columns used for row identification, while SET_PARAMETER tunes apply process behaviour.

Parameter lists are not reproduced here; callers should consult the Oracle Database PL/SQL Packages and Types Reference for the exact signatures.

Tables Accessed

The ETRM metadata records no EBS application tables referenced through APPS synonyms. The package operates instead against the Oracle Streams data dictionary, including views such as ALL_APPLY_ERROR_MESSAGES and DBA_APPLY_ERROR_MESSAGES, which are listed as dependent objects. Internal packages including DBMS_APPLY_ADM_INTERNAL, DBMS_APPLY_ERROR, DBMS_STREAMS_ADM_UTL and DBMS_XSTREAM_ADM reference this package, confirming that it reads and writes Streams configuration and error state rather than EBS transactional tables.

Usage Notes

DBMS_APPLY_ADM is normally invoked indirectly. In EBS 12.1.1 and 12.2.2 it is reached through DBMS_STREAMS_ADM or DBMS_XSTREAM_ADM when administrators configure data propagation, and through DBMS_STREAMS_SM, DBMS_STREAMS_MT and DBMS_LOGREP_UTIL during internal framework operations. Direct calls are appropriate for custom Streams implementations, for example to restart a stalled apply process, to re-execute errors collected in the apply error queue, or to register a DML handler for a specific table. Because the package is owned by SYS, the executing account requires EXECUTE privilege and, for most operations, DBA-level authority; it should therefore be used sparingly and with change control in production EBS environments.