Search Results dbms_apply_adm_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_APPLY_ADM_INTERNAL is an Oracle-supplied PL/SQL package that forms part of the internal infrastructure supporting Oracle Streams and XStream Apply processing. It is owned by the SYS schema and holds a VALID status in the ETRM registry for Oracle E-Business Suite 12.1.1 and 12.2.2. The package operates exclusively as an internal, undocumented support layer: it is not intended for direct invocation by application developers, and it is not exposed through any EBS public API. Its business function is to implement the lower-level administrative operations that govern apply processes, apply servers, and apply queue configuration, marshalling those operations so that the public administrative packages referenced by DBAs and EBS administrators can perform their tasks. In practice, DBMS_APPLY_ADM_INTERNAL is invisible to functional users and normal EBS runtime paths; it is only engaged when Streams or XStream replication features are configured and managed within the database.

Key Procedures and Functions

The ETRM metadata documents zero published procedures or functions for this package, and no standalone callable interface is exposed. This is consistent with its classification as an internal implementation package rather than a public API. All callable behavior is surfaced through the outer packages that DBMS_APPLY_ADM_INTERNAL supports. Consequently, no parameter lists or entry points are published, and the package should be treated as a private dependency. Any code that attempts to invoke it directly would be relying on undocumented, version-specific behavior and is not supported.

Tables Accessed

The ETRM extract documents no tables referenced through APPS synonyms for this package. This is expected, since the package resides in SYS and operates on Streams and XStream metadata using fully qualified SYS-owned dictionary and queue infrastructure rather than EBS application tables. Because no APPS-synonym table access is recorded, the package does not participate in the EBS data model directly. The absence of documented table references also means that any auditing of its statement-level activity must be performed through standard database dictionary views for Streams configuration rather than through EBS object dependency reports.

Usage Notes

DBMS_APPLY_ADM_INTERNAL depends on SYS.DBMS_UTILITY and the STANDARD package, and the ETRM dependency listing confirms it is referenced by thirteen other packages, including DBMS_APPLY_ADM, DBMS_APPLY_ERROR, DBMS_APPLY_HANDLER_INTERNAL, DBMS_CAPTURE_ADM_INTERNAL, DBMS_STREAMS_ADM_IVK, DBMS_STREAMS_ADM_UTL, DBMS_STREAMS_HANDLER_INTERNAL, DBMS_XSTREAM_ADM_UTL, and DBMS_XSTREAM_GG_ADM. This dependency graph shows the package as a central internal conduit between the apply, capture, Streams, and XStream administrative families. It is invoked indirectly whenever a DBA creates, alters, starts, stops, or drops an apply process, or configures apply-related rules and handlers through the supported Streams or XStream administration APIs. In an Oracle EBS environment, this is relevant only where Advanced Replication, Streams, or XStream functionality has been deliberately enabled, such as during logical standby or data replication configuration. It is never called from EBS forms, concurrent programs, or supported custom code. Because the package is internal and undocumented, administrators should continue to use DBMS_APPLY_ADM and the other public wrapper packages, which invoke DBMS_APPLY_ADM_INTERNAL on their behalf.