Search Results dbms_repcat_add_master




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_ADD_MASTER is an Oracle-supplied PL/SQL package that forms part of the Oracle Advanced Replication infrastructure used by Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to support the registration of a new master site (master group) within a multi-master replication environment. In EBS deployments, multi-master replication is commonly associated with distributed topologies in which multiple database instances — for example, a central headquarters instance and one or more regional or subsidiary instances — must maintain synchronised copies of shared application data.

The package is owned by SYS and is classified under the ETRM OTHER API classification. It is not an EBS application-level API and does not reside in the APPS schema. Rather, it is a database-internal helper package referenced by the broader replication catalogue machinery. Within the EBS technical stack, the package is effectively a low-level component that participates in the propagation and quiescing logic managed by higher-level replication APIs.

Key Procedures and Functions

The ETRM metadata records zero explicitly documented procedures or functions for this package. This is consistent with its role as an internal helper rather than a user-facing API. No parameter lists are published in the available documentation, and none should be assumed.

Functionally, the package body serves the replication catalogue by resolving and registering master-site metadata during replication setup operations. It is referenced by three other packages: DBMS_REPCAT_DEFINER, DBMS_REPCAT_RPC, and DBMS_REPCAT_UTL3. The presence of DBMS_REPCAT_RPC and DBMS_REPCAT_UTL3 among the referencing objects indicates that the package is invoked indirectly through remote-procedure-call and utility layers when replication administrative commands are issued.

Its own dependencies are limited to DBMS_UTILITY and the STANDARD package, confirming that it relies on generic PL/SQL utilities rather than on EBS application tables or views.

Tables Accessed

The ETRM documentation does not list any tables accessed through EBS APPS synonyms. This is expected: the package operates against the Oracle replication catalogue — the SYS-owned dictionary objects that store master group definitions, site registrations, and replication status. Because these objects are owned by SYS and are not exposed through APPS synonyms, they fall outside the scope of the APPS-synonym table listing captured in ETRM.

Practically, any reads or writes performed by this package occur within the replication metadata tables rather than against EBS transactional or setup tables. Custom code should therefore not attempt to join this package's activity to application-level data.

Usage Notes

DBMS_REPCAT_ADD_MASTER is not intended for direct invocation from EBS forms, concurrent programs, or custom code. It is called internally by the replication administration stack, principally through DBMS_REPCAT_RPC and DBMS_REPCAT_UTL3, during the execution of replication setup and maintenance commands.

In EBS 12.1.1 and 12.2.2, multi-master replication is a legacy configuration option and is not part of the standard single-instance EBS deployment. Administrators encountering this package are typically working with an inherited distributed configuration, often configured years earlier. Because the package is SYS-owned and internal, it should be treated as read-only infrastructure: it must not be altered, and custom code must not depend on its signature or behaviour, since Oracle may change internal replication helpers between database releases without notice.