Search Results drop_template_parm

Overview

SYS.DBMS_REPCAT_RGT is the Oracle-supplied PL/SQL package that provides the runtime administration interface for Refresh Group Templates within Oracle's Advanced Replication infrastructure, which underpins the Oracle E-Business Suite 12.1.1 and 12.2.2 multi-tier deployment model. Refresh group templates allow administrators to define a reusable, parameterized set of objects (tables, views, and supporting structures) that can be instantiated consistently across multiple replication sites. In the EBS context, this is central to deploying and maintaining read-only snapshots and materialized views used by reporting, self-service, and distributed transaction environments.

The package operates against the replication catalog (the SYS-owned REPCAT* repository tables) and exposes a stable programmatic surface for creating, altering, copying, and dropping templates and their component objects. Because it is owned by SYS and granted to PUBLIC, it is callable from any schema with the appropriate privileges, making it the standard entry point for DBAs automating multi-site replication deployments.

Key Procedures and Functions

The package exposes a documented set of procedures for managing templates, their contained objects, template parameters, user parameter values, and user authorizations. The principal groups are:

• Template lifecycle: CREATE_REFRESH_TEMPLATE, ALTER_REFRESH_TEMPLATE, COPY_TEMPLATE, and DROP_REFRESH_TEMPLATE create, modify, duplicate, or remove a refresh group template definition.
• Template object management: CREATE_TEMPLATE_OBJECT, ALTER_TEMPLATE_OBJECT, and DROP_TEMPLATE_OBJECT add or modify individual database objects within a template.
• Parameter management: CREATE_TEMPLATE_PARM, ALTER_TEMPLATE_PARM, and DROP_TEMPLATE_PARM define the substitutable parameters used when a template is instantiated at a target site.
• User parameter values: CREATE_USER_PARM_VALUE, ALTER_USER_PARM_VALUE, DROP_USER_PARM_VALUE, and DROP_ALL_USER_PARM_VALUES set user-specific values for those parameters.
• Authorization management: CREATE_USER_AUTHORIZATION, ALTER_USER_AUTHORIZATION, and DROP_USER_AUTHORIZATION grant or revoke a user's right to instantiate a template.
• Bulk cleanup: DROP_ALL_OBJECTS, DROP_ALL_TEMPLATE_PARMS, and DROP_ALL_USER_AUTHORIZATIONS provide mass removal of template components.

Tables Accessed

The package reads and writes the System Replication catalog tables, including REPCAT_REFRESH_TEMPLATES, REPCAT_TEMPLATE_OBJECTS, REPCAT_TEMPLATE_PARMS, REPCAT_USER_PARM_VALUES, and REPCAT_USER_AUTHORIZATIONS. These store template metadata, object membership, parameter definitions, user-specific parameter values, and access authorizations, respectively. Persistent changes here directly drive the behavior of downstream instantiation APIs.

Usage Notes

DBMS_REPCAT_RGT is generally invoked by DBAs and automated deployment scripts rather than directly from EBS forms or concurrent programs. It is the foundation on which DBMS_REPCAT_INSTANTIATE and its sibling packages (DBMS_REPCAT_RGT_ALT, DBMS_REPCAT_RGT_CUST, and the utility/checker packages) depend. Custom code should treat these as SYS-owned internals, invoke them only against a healthy replication catalog, and back up the repcat schema before bulk DROP_ALL_* operations.