Search Results dbms_repcat_admin




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_ADMIN is a core Oracle-supplied PL/SQL package that forms part of the Advanced Replication infrastructure underpinning the Oracle E-Business Suite 12.1.1 and 12.2.2 multitenant-capable database tier. It exposes administrative APIs used to configure and maintain replication administrator accounts and to grant the privileges required for administering replicated object groups. In the EBS context, this package supports the deployment of multi-master and read-only replication topologies, most notably the configuration of the replication site that supports Mobile Field Service, Enterprise Asset Management, and distributed applications where data must be synchronized between the master database and subordinate sites.

The package is installed under the SYS schema and is marked VALID in the ETRM 12.2.2 metadata. It is exposed publicly via a PUBLIC synonym, allowing calls from application schemas such as APPS and from the EBS system administration accounts. Because it belongs to the Advanced Replication product option, its availability depends on that option having been installed and on the database version remaining within the supported range for the EBS release.

Key Procedures and Functions

The ETRM metadata for this package documents no individual procedures or functions; the package is classified as OTHER with zero recorded entry points. Its documented behavior is therefore understood through its dependency footprint rather than a published API listing. Functionally, DBMS_REPCAT_ADMIN provides the administrative APIs that create replication administrators, grant and revoke the privileges needed to administer replicated object groups, and manage the user accounts that own replication groups.

  • Replication administrator creation and maintenance — establishes database users and grants the role privileges required to administer replicated objects.
  • Privilege grant and revoke operations — controls which administrators may create or modify object groups.
  • Administrator registration support — records administrator-to-group associations consumed by the broader replication catalog.

Tables Accessed

ETRM does not list any tables accessed through APPS synonyms for this package. The dependency information instead shows a direct reference to SYS.DBMS_UTILITY, indicating that the package relies on utility routines for identifier handling and dynamic SQL generation. In operation the package reads and writes the Advanced Replication dictionary tables owned by SYS, including the administrator and object-group catalog structures that define replication membership and privilege assignments. The absence of APPS-synonym references confirms that DBMS_REPCAT_ADMIN operates exclusively against the SYS replication schema and is not intended to touch EBS application tables directly.

Usage Notes

DBMS_REPCAT_ADMIN is an administrative rather than an end-user API. It is typically invoked from SQL*Plus or another privileged client while logged in as a replication administrator, or executed indirectly by higher-level packages such as DBMS_REPCAT, DBMS_DEFER_SYS, and DBMS_REPCAT_UTL. The ETRM dependency section confirms this role: fifteen other SYS packages reference DBMS_REPCAT_ADMIN, including DBMS_DEFER, DBMS_DEFER_INTERNAL_SYS, DBMS_DEFER_QUERY, DBMS_DEFER_SYS, DBMS_DEFER_SYS_DEFINER, DBMS_OFFLINE_OG, DBMS_OFFLINE_RGT, DBMS_OFFLINE_SNAPSHOT, DBMS_RECTIFIER_DIFF, DBMS_REPCAT, DBMS_REPCAT_SNA, DBMS_REPCAT_SNA_UTL, DBMS_REPCAT_UTL, DBMS_REPCAT_UTL3, and DBMS_REPCAT_UTL4, in addition to a recursive reference to itself. This dependency pattern demonstrates that the package sits near the base of the replication stack and is consumed by snapshot, deferred transaction, offline instantiation, and rectification subsystems.

Because it is not documented as referenced by any EBS form, concurrent program, or APPS synonym, custom code should not call DBMS_REPCAT_ADMIN directly for application logic. Direct invocation is reserved for replication setup and troubleshooting performed by a DBA, and any use should be preceded by validation against Oracle Support guidance for the specific EBS release and database version in use, since Advanced Replication has been desupported in later Oracle Database releases and remains supported only for legacy EBS deployments.