Search Results dbms_repcat_obj_utl

Overview

SYS.DBMS_REPCAT_OBJ_UTL is an Oracle-supplied, internal PL/SQL package that forms part of the symmetric replication infrastructure underpinning Oracle E-Business Suite environments running on Oracle Database 11g or 12c, as shipped with EBS 12.1.1 and 12.2.2. The package belongs to the DBMS_REPCAT family of utilities whose collective responsibility is to configure, propagate, and maintain replicated database objects across multiple sites, including materialized views, master groups, and deferred transaction queues. Within this family, DBMS_REPCAT_OBJ_UTL provides object-level utility services: it assists the higher-level replication administration packages in identifying, validating, and manipulating the database objects that participate in a replication group.

The package is owned by SYS and reports a status of VALID in the ETRM catalog. Its classification is OTHER, reflecting that it is not a documented end-user API but rather a supporting internal component. Oracle does not publish a public call interface for it, and it is not intended to be invoked directly by application code, DBAs, or Oracle EBS customization.

Key Procedures and Functions

The ETRM documentation lists zero documented procedures or functions for DBMS_REPCAT_OBJ_UTL. This is consistent with its role as an internal helper package rather than a published API surface. No parameter lists or callable signatures are recorded in the ETRM metadata, and none should be assumed.

Functionally, the package participates in the object-handling layer of the replication subsystem. Its dependents — including DBMSOBJG, DBMS_REPCAT_CONF, DBMS_REPCAT_FLA_UTL, DBMS_REPCAT_RPC, and the DBMS_REPCAT_UTL series — call into it for object resolution and catalog operations that precede replication group generation and deferred transaction propagation. Itself depends on DBMS_DEFERGEN, DBMS_REPCAT_DECL, DBMS_UTILITY, and STANDARD.

Tables Accessed

The ETRM extract for this object does not enumerate any tables accessed through APPS synonyms. Because the package executes under SYS and operates in the replication dictionary domain, its data access is directed at internal SYS-owned replication catalog views and tables — such as the DEF$_ and REPCAT$_ families — rather than at EBS application tables. Any application-visible effect occurs indirectly, through the replication administration routines that consume its output. Consequently, no EBS business tables are documented as read or written by this package.

Usage Notes

DBMS_REPCAT_OBJ_UTL is invoked implicitly by Oracle's Advanced Replication components. Within an Oracle EBS 12.1.1 or 12.2.2 environment, it is reached only when replication configuration or maintenance routines execute, for example during setup of multi-site synchronization, materialized view refresh administration, or diagnostic walks of the replication object graph. It is referenced by sixteen other packages, including DBMS_REPCAT_INTERNAL, DBMS_REPCAT_MAS, DBMS_REPCAT_UTL2, DBMS_REPCAT_UTL3, and DBMS_REPCAT_UTL4.

Oracle EBS forms and concurrent programs do not call this package directly, and custom code should never do so: the interface is neither documented nor stable across releases. Its presence in a dependency listing is typically encountered during impact analysis, patching investigations, or troubleshooting of replication and materialized view failures. For such diagnostics, the supported approach is to work through the documented DBMS_REPCAT interfaces and Oracle's replication administration utilities rather than invoking this internal package.

PACKAGE: SYS.DBMS_REPCAT_OBJ_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_OBJ_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_OBJ_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_OBJ_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_OBJ_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_OBJ_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_OBJ_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_OBJ_UTL, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
FUNCTION: SYS.GET_OLDVERSION_HASHCODE2 12.2.2
owner:SYS, object_type:FUNCTION, object_name:GET_OLDVERSION_HASHCODE2, status:VALID,
FUNCTION: SYS.GET_OLDVERSION_HASHCODE2 12.1.1
owner:SYS, object_type:FUNCTION, object_name:GET_OLDVERSION_HASHCODE2, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG2 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG2, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_OBJ_UTL 12.1.1
PACKAGE: SYS.DBMS_REPUTIL2 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPUTIL2, status:VALID,
PACKAGE: SYS.DBMS_REPUTIL2 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPUTIL2, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_SNAPSHOT_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SNAPSHOT_UTL, status:VALID,
PACKAGE: SYS.DBMS_SNAPSHOT_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SNAPSHOT_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_FLA_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_FLA_MAS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA_MAS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_FLA 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_FLA_MAS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA_MAS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_OBJ_UTL 12.2.2
PACKAGE BODY: SYS.DBMS_REPCAT_FLA_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_DECL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_DECL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG_DP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG_DP, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG2 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG2, status:VALID,
VIEW: SYS.DBA_REPFLAVOR_OBJECTS 12.1.1
owner:SYS, object_type:VIEW, object_name:DBA_REPFLAVOR_OBJECTS, status:VALID,
PACKAGE: SYS.DBMS_INTERNAL_TRIGGER 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_INTERNAL_TRIGGER, status:VALID,
PACKAGE: SYS.DBMS_INTERNAL_TRIGGER 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_INTERNAL_TRIGGER, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG_DP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG_DP, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_FLA 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA, status:VALID,
VIEW: SYS.DBA_REPFLAVOR_OBJECTS 12.2.2
owner:SYS, object_type:VIEW, object_name:DBA_REPFLAVOR_OBJECTS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_DEFINER 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_DEFINER, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_CONF 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_CONF, status:VALID,
TABLE: SYS.REFCON$ 12.2.2
owner:SYS, object_type:TABLE, object_name:REFCON$, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RPC 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL2 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL2, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_DEFINER 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_DEFINER, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_CONF 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_CONF, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RPC 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL2 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL2, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG, status:VALID,
TABLE: SYS.REFCON$ 12.1.1
owner:SYS, object_type:TABLE, object_name:REFCON$, status:VALID,
PACKAGE BODY: SYS.DBMSOBJG 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMSOBJG, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SNA_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SNA_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MAS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL4 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MAS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MAS, status:VALID,