Search Results dbms_repcat_definer




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_DEFINER is an Oracle-supplied PL/SQL package that forms part of the symmetric replication infrastructure bundled with the Oracle database. Because the package is owned by SYS and shipped in wrapped (obfuscated) form, its internal logic is not exposed in readable source. In Oracle E-Business Suite 12.1.1 and 12.2.2, the package supports the replication administration model in which trusted definer's-rights operations are carried out on behalf of replication administrators, allowing privileged catalogue maintenance to proceed without granting those administrators direct DDL or DML privileges on the underlying replication metadata. The package is therefore best understood as a supporting internal component of the Advanced Replication / Oracle Streams administrative layer rather than as an EBS application object.

Key Procedures and Functions

The ETRM metadata for this object records no publicly documented procedures or functions. Consistent with other wrapped SYS-owned replication packages, its entry points are designed for internal invocation by the replication administration framework and related DBMS_REPCAT-family packages. No parameter lists, signatures, or callable interfaces are exposed in the documented metadata, and readers should not assume a stable public API. Where the package is referenced, it is by other replication infrastructure code rather than by application developers.

Tables Accessed

The ETRM metadata lists no tables referenced through APPS synonyms, which is expected for a SYS-owned replication package: any objects it touches reside in the SYS schema (the SYSTEM and replication catalogue tables used by the DBMS_REPCAT family), not in APPS or the EBS product schemas. Consequently, no EBS application tables are read or written by this package, and no APPS synonym mapping applies.

Usage Notes

The metadata records that the package is referenced by one other package, confirming its role as a subordinate internal dependency rather than a directly invoked API. In an EBS 12.1.1 or 12.2.2 environment, DBMS_REPCAT_DEFINER is exercised only when the replication subsystem performs privileged definer's-rights work; it is not called from EBS forms, concurrent programs, or standard application flows. Custom code should never depend on it, as it is an Oracle internal component and may change or be removed across database releases. Administrators performing replication setup or troubleshooting should rely on the documented public DBMS_REPCAT interfaces instead of targeting this package directly.

Note: the search term associated with this lookup ("三菱fto") does not correspond to any Oracle EBS object and is unrelated to this package; no EBS artefact of that name exists in the ETRM catalogue.