Search Results dbms_repcat_mas

Overview

DBMS_REPCAT_MAS is an Oracle-supplied PL/SQL package owned by the SYS schema and shipped with the Oracle RDBMS server, where it forms part of the internal infrastructure supporting Oracle Advanced Replication. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package is present as a system object that supports the replication management layer used to propagate and synchronize data across distributed database instances. Although it is not an EBS application-level API and carries no APPS synonym equivalent, its presence is recorded in the ETRM repository because EBS dependencies traverse it during dependency analysis of replication-enabled schemas.

The package status is VALID, confirming that the package specification and package body are compiled and usable in the database at the time of documentation. Its API classification is OTHER, indicating that it is neither a public EBS business API nor a documented extension point but rather an internal Oracle Replication support package. The business function it serves is the management of master-group and master-site metadata during multi-master replication configuration, effectively acting as a security-definer wrapper and internal utility layer that the higher-level DBMS_REPCAT family of packages calls upon.

Key Procedures and Functions

The ETRM documentation for DBMS_REPCAT_MAS records zero documented procedures or functions. This is consistent with its role as an internal Oracle package: Oracle does not publish a supported callable interface for DBMS_REPCAT_MAS, and its entry points are not intended for direct invocation by DBMS_REPCAT_MAS or by application code. The ETRM catalog records only the package and package body subobjects.

Internally, the package provides security-definer execution wrappers around calling packages such as DBMS_REPCAT, DBMS_REPCAT_DECL, DBMS_SYS_SQL, DBMS_UTILITY, and STANDARD. These generate and execute replication DDL and administrative statements under controlled privileges. Because no procedure names or parameter lists are documented, no signature-level detail can be asserted.

Tables Accessed

The ETRM metadata documents no table references for DBMS_REPCAT_MAS through APPS synonyms. This is expected, as the package operates within the SYS schema against replication dictionary views and base tables rather than EBS application tables. The referenced packages—principally DBMS_REPCAT and DBMS_REPCAT_DECL—perform the actual catalog manipulation, while DBMS_REPCAT_MAS supplies the internal dispatch and privilege-handling logic. Reading or writing application tables does not form part of its documented behavior.

Usage Notes

DBMS_REPCAT_MAS is referenced by ten other packages: DBMS_OFFLINE_OG_INTERNAL, DBMS_REPCAT, DBMS_REPCAT_ADD_MASTER, DBMS_REPCAT_CONF, DBMS_REPCAT_DEFINER, DBMS_REPCAT_FLA_MAS, DBMS_REPCAT_MAS itself, DBMS_REPCAT_RPC, DBMS_REPCAT_UTL2, DBMS_REPCAT_UTL3, and DBMS_REPCAT_UTL4. This dependency graph confirms that it is invoked indirectly whenever multi-master or offline object-group replication operations are performed, including master-group creation, master-site addition, and replication configuration changes. It is not directly invoked by EBS forms, concurrent programs, or custom code, and Oracle does not support calling it explicitly. In EBS 12.1.1 and 12.2.2 environments, the package remains valid but dormant unless Advanced Replication has been configured; its existence matters chiefly for dependency tracking, patching analysis, and impact assessment when replication features are enabled.

PACKAGE: SYS.DBMS_REPCAT_MAS 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_MAS 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MAS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MAS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE: SYS.DBMS_ALERT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ALERT, status:VALID,
PACKAGE: SYS.DBMS_ALERT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ALERT, status:VALID,
PACKAGE: SYS.DBMSOBJG 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMSOBJG, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_CACHE 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_CACHE, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_FLA 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_FLA, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_CACHE 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_CACHE, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_CONF 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_CONF, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_CONF 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_CONF, status:VALID,
PACKAGE: SYS.DBMSOBJG 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMSOBJG, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_RPC 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_RPC 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE: SYS.DBMS_REPUTIL2 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPUTIL2, status:VALID,
PACKAGE: SYS.DBMS_DEFER_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_REPCAT, status:VALID,
PACKAGE: SYS.DBMS_DEFER_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_REPCAT, status:VALID,
PACKAGE: SYS.DBMS_REPUTIL2 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPUTIL2, status:VALID,
VIEW: SYS._DBA_REPL_NESTED_TABLE_NAMES 12.1.1
owner:SYS, object_type:VIEW, object_name:_DBA_REPL_NESTED_TABLE_NAMES, status:VALID,
VIEW: SYS._DBA_REPL_NESTED_TABLE_NAMES 12.2.2
owner:SYS, object_type:VIEW, object_name:_DBA_REPL_NESTED_TABLE_NAMES, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_FLA 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_FLA, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL3 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL3 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL4 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL4 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_OG_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SQL_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SQL_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SQL_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SQL_UTL, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_FLA_MAS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA_MAS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_FLA_MAS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA_MAS, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL2 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL2, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_DECL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_DECL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE: SYS.DBMS_SNAP_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SNAP_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_OBJ_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_OBJ_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_OG_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RPC 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_DEFINER 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_DEFINER, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_CONF 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_CONF, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_OBJ_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_OBJ_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL2 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL2, status:VALID,