Search Results dbms_internal_repcat




Overview
Explore in AI Chat

Overview

SYS.DBMS_INTERNAL_REPCAT is an Oracle-supplied internal PL/SQL package that forms part of the symmetric replication infrastructure underpinning Oracle E-Business Suite environments at releases 12.1.1 and 12.2.2. It resides in the SYS schema with a status of VALID and is classified under the generic API category "OTHER," indicating that it is not an EBS application-tier API but rather a database kernel component exposed to the EBS instance through the underlying Oracle RDBMS. Its principal role is to act as an internal wrapper and helper layer around the public DBMS_REPCAT package, which is the documented administrative interface for Oracle advanced replication. In EBS deployments, replication technology has historically been used for multi-node configurations, such as sharing reference and setup data across multiple database tiers, and for certain upgrade and cloning operations where schema-level consistency must be maintained across instances.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents no public procedures or functions for this package. This is consistent with its classification as an internal, undocumented kernel package: its entry points are not published for direct customer invocation and are not catalogued in the EBS API registry. Functionally, the package depends upon DBMS_REPCAT and the STANDARD package, and it is referenced by PUBLIC and SYS through its own name, confirming that it is resolvable as a public synonym but intended strictly for internal consumption by the replication engine. Any callable behavior it exposes is therefore an implementation detail subject to change across database patch levels and must not be treated as a stable interface.

Tables Accessed

No tables are documented as being accessed by SYS.DBMS_INTERNAL_REPCAT through APPS synonyms, and no dependent objects are recorded against EBS application tables. At the database level, packages of this family operate against the Oracle replication catalog views and dictionary structures, including the DEF$_ and REPCAT$_ families maintained by the replication subsystem, but the ETRM metadata for this object does not enumerate such references. Accordingly, no EBS application table reads or writes can be attributed to this package on the basis of the available documentation.

Usage Notes

Because SYS.DBMS_INTERNAL_REPCAT is an internal RDBMS package rather than an EBS API, it is not invoked from Oracle Forms, concurrent programs, or supported customization code. Its dependency graph shows a single downstream dependency on DBMS_REPCAT, and it is referenced by PUBLIC and SYS only, which reinforces that all invocation paths are internal to the database. Direct calls from custom EBS code are strongly discouraged: the package is undocumented, unversioned from an application perspective, and may be altered or removed by database patches without notice. The EBS 12.1.1 and 12.2.2 documentation records the object solely for dependency and reference purposes, and any replication administration in those releases should be performed through the supported DBMS_REPCAT interface or through EBS-provided utilities rather than through this internal package.