Search Results dbms_offline_og_internal

Overview

SYS.DBMS_OFFLINE_OG_INTERNAL is an Oracle-supplied internal PL/SQL package body that supports offline instantiation of replicated object groups. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack, this package operates beneath the public DBMS_OFFLINE_OG interface, providing the private implementation layer that Oracle's Advanced Replication engine uses to perform the "offline instantiation" workflow—a bulk, offline method for materializing a master or snapshot group at a remote site without transmitting the full object data over the network at creation time.

The package is owned by SYS and is documented in the ETRM as VALID. It is classified as OTHER, meaning it is not part of the Applications schema (APPS) API surface and is not intended for direct customer invocation. Instead, it is a supporting component invoked by higher-level replication packages during the offline instantiation sequence.

Key Procedures and Functions

The ETRM metadata documents zero public procedures or functions for DBMS_OFFLINE_OG_INTERNAL. This is consistent with its role as an internal helper package. It encapsulates the routine behaviors required to:

Initiate and coordinate the offline instantiation process for a replicated object group.
Execute the individual replication steps (create group, populate objects, generate deferred transactions) invoked by the outer public API.
Maintain internal bookkeeping used to resume or complete offline instantiation after the data set has been transported to the target site.

Custom code should never call this package directly; equivalent functionality is exposed through DBMS_OFFLINE_OG.

Tables Accessed

The documented dependency list shows references to the core Advanced Replication data dictionary tables REPCAT$_REPCATLOG and REPCAT$_REPOBJECT. REPCAT$_REPOBJECT stores metadata about each replicated object (group member) and is read to identify what must be instantiated. REPCAT$_REPCATLOG is the deferred transaction log and is written as replication administrative changes are queued for propagation. Both are SYS-owned dictionary tables and are not intended for direct customer access.

Usage Notes

The package is invoked exclusively by Oracle's replication infrastructure. Custom application code, forms, and concurrent programs in Oracle EBS do not call DBMS_OFFLINE_OG_INTERNAL. When a DBA performs offline instantiation—typically via the DBMS_OFFLINE_OG public package or Oracle Enterprise Manager's replication management interface—the runtime chain dispatches through this internal body.

The ETRM notes that the package is referenced by exactly one other package and references none of the EBS application synonyms, confirming its narrow, infrastructure-only scope. Its presence in a system is a normal artifact of Oracle Advanced Replication. In EBS environments where replication is not configured, the object exists but remains dormant. It should not be modified, recompiled against custom logic, or dropped, as doing so would break underlying replication dependencies.

PACKAGE BODY: SYS.DBMS_OFFLINE_OG_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_OG_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_OG_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_OFFLINE_OG_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_OG_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_OFFLINE_OG_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_OG_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_OG 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_OFFLINE_OG, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_OG 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_OFFLINE_OG, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_OG, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_OG_INTERNAL 12.1.1
PACKAGE: SYS.DBMS_REPCAT_UTL3 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_OFFLINE_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_OFFLINE_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_OG, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_OG_INTERNAL 12.2.2
PACKAGE: SYS.DBMS_OFFLINE_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_OFFLINE_UTL, status:VALID,
PACKAGE: SYS.DBMS_OFFLINE_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_OFFLINE_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_RPC 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_RPC 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE: SYS.DBMS_DEFER_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_REPCAT, status:VALID,
PACKAGE: SYS.DBMS_DEFER_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_REPCAT, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SNA_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SNA_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SNA_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SNA_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL4 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL4 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_MAS 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_MAS 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL3 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE: SYS.DBMS_DB_VERSION 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DB_VERSION, status:VALID,
PACKAGE: SYS.DBMS_DB_VERSION 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DB_VERSION, status:VALID,
PACKAGE: SYS.DBMS_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG_INTERNAL 12.2.2
PACKAGE: SYS.DBMS_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG_INTERNAL 12.1.1
PACKAGE: SYS.DBMS_REPCAT_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL, 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$_REPOBJECT 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_REPOBJECT, 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,
TABLE: SYSTEM.REPCAT$_REPOBJECT 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_REPOBJECT, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, status:VALID,
TABLE: SYSTEM.REPCAT$_REPCATLOG 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_REPCATLOG, status:VALID,
TABLE: SYSTEM.REPCAT$_REPCATLOG 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_REPCATLOG, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, status:VALID,
PACKAGE: SYS.DBMS_SQL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SQL, status:VALID,
PACKAGE: SYS.DBMS_SQL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SQL, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
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,