Search Results dbms_repcat_rgt_cust2




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_RGT_CUST2 is an internal Oracle-supplied PL/SQL package that forms part of the Oracle Advanced Replication infrastructure supporting Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its owner is the SYS schema, and its status is VALID. The suffix "RGT" identifies the package as belonging to the Replication Group Template (RGT) family, while "CUST2" indicates it is a secondary customization support package. This family provides the programmatic foundation used by Oracle's replication management tools to instantiate, populate, and maintain refresh group templates, including the "Seed" and "Instantiation" logic that governs how replicated object definitions are propagated to target master sites.

Within EBS, this package is not exposed to end users or Oracle Applications developers. It is invoked indirectly by the higher-level replication management APIs SYS.DBMS_REPCAT_RGT and SYS.DBMS_REPCAT_RGT_CUST when administrators configure multi-master or materialized-view replication topologies. Its primary business function is to encapsulate the second-tier customization logic required when template definitions must be adjusted programmatically rather than through the standard replication management interface.

Key Procedures and Functions

The ETRM metadata for this object documents zero externally declared procedures or functions. The package declares both a specification and a body, but all internal units are considered private implementation details and are not published for direct invocation. Because the documented procedure list is empty, no parameter lists are reproduced here, and by policy they are not fabricated. In practice, the routines contained in DBMS_REPCAT_RGT_CUST2 are called exclusively by DBMS_REPCAT_RGT and DBMS_REPCAT_RGT_CUST, both of which reference it in the dependency chain. Administrators should treat the package's contents as opaque and interact only with the documented public replication APIs.

Tables Accessed

The ETRM metadata does not list any APPS-synonym-accessible tables referenced by this package. Its documented dependencies are entirely on other PL/SQL units: SYS.DBMS_SNAPSHOT_UTL, SYS.DBMS_SQL, and STANDARD. DBMS_SQL indicates that the package performs dynamically constructed SQL, which is typical of replication code that must generate object-specific DDL and DML at runtime. DBMS_SNAPSHOT_UTL signals that the package manipulates materialized view (snapshot) definitions. Consequently, the tables it actually touches are those referenced within dynamically generated statements, likely the replication catalog views and underlying ${SYSTEM}.DEF$_% tables maintained by Advanced Replication.

Usage Notes

DBMS_REPCAT_RGT_CUST2 is referenced by two packages: SYS.DBMS_REPCAT_RGT and SYS.DBMS_REPCAT_RGT_CUST. It also references itself recursively, confirming nested internal calls. There is no evidence of direct invocation from Oracle EBS forms, concurrent programs, or application-level PL/SQL. The package should never be called directly from custom code. Any attempt to do so risks corrupting replication metadata, bypassing the validation logic enforced by the public Replication Manager APIs. In EBS environments, replication setup is normally driven through the Oracle Replication Manager or through DBMS_REPCAT_RGT and DBMS_REPCAT_RGT_CUST, which in turn exercise this package internally. Customization efforts should be applied at the template definition level, not against this internal support package, to preserve upgrade integrity across EBS 12.1.1 and 12.2.2.