Search Results dbms_repcat_rgt_alt




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_RGT_ALT is an Oracle-supplied PL/SQL package that forms part of the internal infrastructure supporting Oracle Advanced Replication and its refresh group template (RGT) subsystem. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package is catalogued with a status of VALID in the SYS schema and is classified under the ETRM API classification of OTHER, indicating that it is not an application-facing public API but rather a backend dependency object.

The package name incorporates the _ALT suffix, which in Oracle replication terminology denotes an "alternate" or helper variant of a primary replication package. It sits alongside DBMS_REPCAT_RGT, the principal package responsible for managing refresh group templates that govern how replicated object groups are refreshed across master and materialized view sites. DBMS_REPCAT_RGT_ALT therefore exists to provide supplementary or alternate code paths that the main template package can call upon, enabling Oracle to expose or route functionality without overloading the primary interface.

Key Procedures and Functions

The ETRM documentation for this object records zero documented procedures or functions. Because Oracle does not publish the callable specification of this internal helper package, no public parameter lists are enumerated here and none should be inferred. The absence of documented entry points is consistent with the object's classification as OTHER and its role as an internal support package.

  • Package specification and body: Both a specification and a package body are present, and the object is reported as VALID, confirming that the compiled code is operative in the environment.
  • Callable interface: The specific procedures and functions are not exposed through Oracle's reference documentation and are not intended for direct invocation by EBS applications or customers.

Tables Accessed

The ETRM metadata does not list any tables referenced by DBMS_REPCAT_RGT_ALT through APPS synonyms, and no underlying replication repository tables are explicitly documented as being read or written by this package. Its dependency chain shows references to the STANDARD package and to the SYS schema itself, which is typical of compiled PL/SQL units that rely on Oracle's built-in SQL and PL/SQL runtime facilities.

Operationally, packages in the RGT family interact with the replication catalogue owned by SYS, including the refresh group template and template parameter definitions used to regenerate replication support at member sites. Because no table access is documented in ETRM, administrators should treat the package as internal and avoid assumptions about which dictionary tables it manipulates.

Usage Notes

DBMS_REPCAT_RGT_ALT is referenced by exactly one other package: SYS.DBMS_REPCAT_RGT. This establishes that the package is not invoked directly by EBS forms, concurrent programs, or user code, but is instead called from within the principal refresh group template package as an internal implementation detail.

  • Direct invocation: Not supported. The package is not exposed as an application API and its procedures are not documented for external callers.
  • Typical context: It executes only as part of replication administration activities driven through DBMS_REPCAT_RGT, such as template creation, instantiation, and refresh processing at materialized view sites.
  • EBS relevance: The package is relevant to EBS environments that deploy Advanced Replication or multi-site data distribution, where refresh group templates are used to propagate configuration data reliably.
  • Change control: Because the package resides in SYS and is internally managed, it must not be modified, replaced, or pinned without Oracle direction; invalidating it can break template-driven replication.

In summary, DBMS_REPCAT_RGT_ALT is a valid but undocumented internal support package within Oracle's replication infrastructure, existing solely to serve DBMS_REPCAT_RGT in Oracle EBS 12.1.1 and 12.2.2.