Search Results dbms_repcat_rgt_exp

Overview

SYS.DBMS_REPCAT_RGT_EXP is an Oracle-supplied PL/SQL package that forms part of the Oracle Advanced Replication infrastructure shipped with the database kernel and surfaced within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack. The suffix "RGT" denotes the Refresh Group Template facility of the replication management API, and the "EXP" element indicates the package's role in exporting and propagating refresh group template definitions. In the EBS context, this package supports the definition, maintenance, and deployment of refresh group templates that govern how materialized view refresh groups are constructed and scheduled across distributed EBS node topologies — for example, between a central instance and read-only or reporting instances.

The package resides in the SYS schema and is reported with a status of VALID in the ETRM 12.2.2 metadata. It is classified under the API classification "OTHER," reflecting its status as an internal database-supplied utility rather than an EBS application-level API.

Key Procedures and Functions

The ETRM metadata documents zero public procedures or functions for this package. Dependency analysis shows that SYS.DBMS_REPCAT_RGT_EXP references only the SYS schema and the STANDARD package — the PL/SQL bootstrap package implicitly available to every compiled unit. The package references itself in the dependency listing, a normal artifact for packages containing both a specification and a body where internal calls resolve within the same unit.

Because no callable routines are catalogued, the package should be understood as an implementation-support unit underpinning the broader DBMS_REPCAT_RGT template API rather than a directly invoked interface. No parameter lists are documented, and none should be assumed.

Tables Accessed

The provided metadata does not enumerate any base tables accessed directly by this package, and no APPS-synonym table references are documented. Typically, replication template processing operates against the underlying replication dictionary objects owned by SYS, such as those storing template definitions, template parameters, and their associated refresh group bindings. Because the documented dependency set is limited to SYS and STANDARD, any dictionary access occurs through static or dynamic SQL executed inside the owning schema rather than through EBS application synonyms.

Usage Notes

This package is an internal Oracle replication component. It is referenced by no other documented packages within the ETRM inventory, and it is not intended for direct invocation from EBS forms, concurrent programs, or custom application code. Practitioners who encounter DBMS_REPCAT_RGT_EXP during dependency tracing or error diagnosis in EBS 12.1.1 or 12.2.2 should treat it as part of the database-supplied Advanced Replication layer, administered through the supported DBMS_REPCAT and DBMS_REPCAT_RGT entry points. Direct calls to its internals are unsupported, and any customization should be confined to the documented replication APIs.

PACKAGE: SYS.DBMS_REPCAT_RGT_EXP 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RGT_EXP, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RGT_EXP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RGT_EXP, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_RGT_EXP 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RGT_EXP, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RGT_EXP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RGT_EXP, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_RGT_EXP 12.1.1
PACKAGE: SYS.DBMS_REPCAT_RGT_CHK 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RGT_CHK, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RGT_EXP 12.1.1
PACKAGE: SYS.DBMS_REPCAT_RGT_EXP 12.2.2
PACKAGE BODY: SYS.DBMS_REPCAT_RGT_EXP 12.2.2
PACKAGE: SYS.DBMS_REPCAT_RGT_CHK 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RGT_CHK, status:VALID,
TABLE: SYS.RGROUP$ 12.1.1
owner:SYS, object_type:TABLE, object_name:RGROUP$, status:VALID,
TABLE: SYS.RGROUP$ 12.2.2
owner:SYS, object_type:TABLE, object_name:RGROUP$, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL, status:VALID,
TABLE: SYSTEM.REPCAT$_TEMPLATE_SITES 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_TEMPLATE_SITES, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL, status:VALID,
TABLE: SYSTEM.REPCAT$_TEMPLATE_SITES 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_TEMPLATE_SITES, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.DBMS_SYS_ERROR 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
PACKAGE: SYS.DBMS_SYS_ERROR 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
SYS.DBMS_REPCAT_RGT_EXP dependencies on DBMS_REPCAT_RGT_EXP 12.1.1
SYS.DBMS_REPCAT_RGT_EXP dependencies on DBMS_REPCAT_RGT_EXP 12.2.2
PACKAGE: SYS.DBMS_STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
TABLE: SYS.DUAL 12.2.2
owner:SYS, object_type:TABLE, object_name:DUAL, status:VALID,
TABLE: SYS.DUAL 12.1.1
owner:SYS, object_type:TABLE, object_name:DUAL, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,