Search Results dbms_repcat_untrusted




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_UNTRUSTED is a server-side PL/SQL package body supplied by Oracle as part of the Advanced Replication infrastructure bundled with the Oracle RDBMS. In Oracle E-Business Suite 12.1.1 and 12.2.2, the package is owned by SYS and is present with a status of VALID. Within the broader DBMS_REPCAT family, the "UNTRUSTED" variant provides a restricted, lower-privilege entry point to replication catalog administration facilities. Its design intent is to expose selected replication management operations to callers that do not hold the elevated privileges normally required to execute the trusted DBMS_REPCAT package directly, allowing controlled invocation from application schemas and trusted server code without granting full replication-administrator rights.

The package does not implement replication logic in isolation. It is an interface and dispatch layer that delegates to the core replication engine and to several supporting utility packages, as evidenced by its documented dependency list. This layered structure keeps security enforcement, catalog maintenance, and snapshot site handling separated into specialized modules.

Key Procedures and Functions

The ETRM documentation for this package body does not enumerate individual procedures or functions; zero documented entry points are recorded. The package source nonetheless exists as a compiled body and exposes callable units consistent with other members of the DBMS_REPCAT family. Because no procedure-level metadata is published, specific routine names, parameter lists, and signatures are deliberately not asserted here. Functionally, the package provides administrative operations for replication groups and their associated objects, delegating the substantive work to the trusted replication utilities it references. Consumers should treat the package as an undocumented internal interface and consult the package specification in the target database for the authoritative list of subprograms.

Tables Accessed

No tables are documented as accessed through APPS synonyms for this object, and no application-level table dependencies are recorded. The package operates against the replication catalog data dictionary rather than against EBS transactional or interface tables. Its dependency list indicates reliance on internal replication utilities — DBMS_REPCAT_DECL, DBMS_REPCAT_FLA_UTL, DBMS_REPCAT_SNA_UTL, and DBMS_REPCAT_UTL — which collectively read and write replication group, object, and site metadata. It also references DBMS_SNAPSHOT, indicating participation in materialized view and snapshot site operations, and STANDARD, the base PL/SQL package. The absence of documented APPS-synonym table access confirms that the package is not intended to read or modify EBS application data directly.

Usage Notes

DBMS_REPCAT_UNTRUSTED is not referenced by any other database object in the ETRM dependency graph and is not exposed through EBS forms, concurrent programs, or standard application flows. It is database infrastructure invoked indirectly by replication administration scripts, DBA utilities, and trusted server-side code during the setup and maintenance of multi-master or snapshot replication environments. Administrators commonly encounter it when configuring replication groups, generating replication support for objects, or administering materialized view sites. Custom code should not call this package directly; because the interface is undocumented and internal, its behavior and signatures may change between database releases. EBS customers running 12.1.1 or 12.2.2 should leave the package untouched and perform replication management through supported, documented Oracle Replication APIs instead.