Search Results dbms_repcat_rgt_chk




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_RGT_CHK is a server-side PL/SQL package that forms part of Oracle's symmetric replication infrastructure, specifically the refresh group template (RGT) subsystem. In Oracle E-Business Suite 12.1.1 and 12.2.2, the object is shipped in the SYS schema with a VALID status and is classified as an OTHER API, indicating that it is not a general-purpose application programming interface exposed for customer extension but rather an internal support component of the replication toolset.

The refresh group template framework allows administrators to define reusable templates that describe how a designated master site should propagate data to and from materialized view sites. The DBMS_REPCAT_RGT_CHK package provides the validation layer for that framework. Its role is to verify that template definitions, parameter bindings, and the input conditions supplied to a template instantiation request are internally consistent and legal before the heavier template generation and deployment routines are permitted to execute. By intercepting invalid or incomplete definitions early, the package prevents partially created refresh groups and reduces the risk of inconsistent replicated data across a multi-tier EBS deployment.

Key Procedures and Functions

The ETRM documentation records no publicly documented procedures or functions for DBMS_REPCAT_RGT_CHK. The package specification and body are listed without individually named callable units, and no parameter signatures are exposed in the metadata. This is consistent with its role as an internal helper package: its routines are intended for consumption by the other members of the DBMS_REPCAT_RGT family rather than by application developers or DBAs.

Functionally, the package supplies check routines that support the parent APIs. These routines validate template parameter metadata, confirm that required values are present, and raise errors when a template request does not satisfy the framework's structural rules. Because no procedure or function is documented, no callable interface should be assumed; any direct invocation would be unsupported.

Tables Accessed

The metadata lists no tables reached through APPS synonyms for this package. This is expected, because DBMS_REPCAT_RGT_CHK operates in the SYS schema against the Oracle replication catalog, not against E-Business Suite application tables. Its checking logic works with the replication metadata dictionary views and internal catalog structures that describe registered refresh group templates, their parameters, and their generated instantiations. No EBS transactional or setup tables are read or written by this component.

Usage Notes

DBMS_REPCAT_RGT_CHK is not invoked from Oracle EBS forms, concurrent programs, or standard application flows. It is called internally by the related replication packages. ETRM dependency data shows the package is referenced by six other packages: DBMS_REPCAT_RGT, DBMS_REPCAT_RGT_ALT, DBMS_REPCAT_RGT_CHK (itself, through internal recursion or overloading), DBMS_REPCAT_RGT_CUST, DBMS_REPCAT_RGT_CUST2, DBMS_REPCAT_RGT_EXP, and DBMS_REPCAT_RGT_UTL. It depends only on the STANDARD package and standard SYS infrastructure.

  • Invoke template maintenance exclusively through the supported parent APIs such as DBMS_REPCAT_RGT; the check package will be exercised automatically.
  • Do not grant EXECUTE on this package to application schemas, and do not call it from custom code, as its interface is undocumented and may change between releases.
  • Treat any error surfaced by this package during template operations as a validation failure in the template definition rather than a defect in the checker.
  • Confirm the package status remains VALID after database upgrades, since an invalid state will block refresh group template operations across the replication topology.