Search Results dbms_offline_rgt_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_OFFLINE_RGT_INTERNAL is a wrapped Oracle Database package owned by the SYS schema and shipped as part of the standard Oracle RDBMS installation. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, it is referenced from the greater Oracle EBS technology stack rather than from a functional application module. The name follows Oracle's internal DBMS_OFFLINE_* naming convention, which is associated with the Oracle Streams and offline instantiation infrastructure. The RGT segment most plausibly denotes "Registration" in the sense of Streams object registration and instantiation metadata management. The package is therefore an internal, undocumented support object whose business function is to assist the database in offline instantiation and registration of replicated objects — the mechanism by which a change capture or apply process is seeded from a pre-built copy of the source database.

Because the source body is WRAPPED, the ETRM classification for this object is OTHER and no callable procedures or functions are exposed in the documented metadata. Its relevance to EBS is indirect: EBS deployments that leverage Streams or Advanced Replication for data distribution, reporting offload, or disaster recovery depend on the offline registration path that this package underpins.

Key Procedures and Functions

The ETRM metadata documents zero procedures or functions for this package. The package body is wrapped in the database and the specification is not published for customer use, so no callable interface should be assumed or referenced from custom code.

By convention with sibling DBMS_OFFLINE_* packages, the internal routines are understood to handle the coordinated registration and instantiation of replicated objects, including bookkeeping for the objects being instantiated and the sequencing of the offline instantiation steps. These are internal implementation details and are not documented entry points. No parameter lists are published in the metadata, and none should be inferred.

Tables Accessed

The ETRM metadata does not document any tables referenced through APPS synonyms; this is consistent with the package operating on SYS-owned dictionary and replication catalog objects rather than on EBS application tables. Any table access performed by the package occurs within the SYS schema and is outside the scope of the EBS data model.

Because the package is wrapped and its table dependencies are not exposed, no EBS application table should be assumed to be read or written by it. The package does not appear in the EBS table access inventory and should not be treated as a data source for EBS reporting or integration.

Usage Notes

DBMS_OFFLINE_RGT_INTERNAL is not invoked directly by Oracle E-Business Suite forms, concurrent programs, or standard application code. The ETRM metadata records that it is referenced by one other package, indicating that it is called internally by the Oracle replication and Streams infrastructure during offline instantiation workflows.

Practical guidance for EBS 12.1.1 and 12.2.2 administrators and developers is as follows:

  • Do not call this package from custom EBS code. It has no documented public interface and its specification may change between database releases.
  • Do not modify, recompile, or invalidate the package. Changes can disrupt Streams or Advanced Replication setup in environments where those features are configured.
  • Treat the accompanying source text, marked Oracle Proprietary and Confidential, as restricted and do not redistribute it.
  • For legitimate replication or cloning requirements in EBS, use the supported utilities — Rapid Clone, Data Pump, or the documented DBMS_* packages — rather than this internal object.
  • If the package shows as INVALID in DBA_OBJECTS, resolve by running the standard database component scripts supplied with the Oracle home; do not attempt manual recompilation of the wrapped body.

In summary, SYS.DBMS_OFFLINE_RGT_INTERNAL is an internal, wrapped RDBMS package supporting offline registration and instantiation of replicated objects. It is present in EBS 12.1.1 and 12.2.2 as part of the underlying database, but it is not part of the supported EBS extension surface and should be treated as read-only infrastructure.