Search Results dbms_asyncrpc_push

Overview

SYS.DBMS_ASYNCRPC_PUSH is an Oracle-supplied, SYS-owned PL/SQL package that forms part of the infrastructure supporting Oracle's deferred remote procedure call (RPC) and asynchronous replication mechanisms. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package is not an Applications product API but a database kernel-level component that underpins the distributed and deferred transaction processing capabilities used by Advanced Replication and, indirectly, by EBS features that rely on deferred execution across database links. The package is documented in ETRM as VALID, with an API classification of OTHER, indicating it is not a supported public interface for direct customer invocation but rather an internal dependency within the Oracle data dictionary.

Its central role is the propagation or "push" of queued asynchronous RPC calls to destination sites. The name reflects its function: DBMS_ASYNCRPC_PUSH handles the delivery phase of deferred RPC queues, transmitting pending calls that have been enqueued by the deferred transaction subsystem.

Key Procedures and Functions

Per the documented ETRM metadata for release 12.2.2, SYS.DBMS_ASYNCRPC_PUSH exposes zero documented procedures or functions. This is consistent with its classification as an internal, proprietary package: Oracle deliberately does not publish a supported callable interface for it. Consequently, no parameter lists, return types, or public entry points are documented, and none are reproduced here. The package should be regarded as a mechanism invoked internally by the replication and deferred transaction stack rather than as a developer-facing API. Any appearance of callable subprograms is undocumented and subject to change between releases and patch sets.

Tables Accessed

The ETRM documentation does not list any tables accessed through APPS synonyms, which is expected given that the package resides in the SYS schema and operates on data dictionary and replication catalog objects rather than on EBS application tables. Functionally, a package of this nature interacts with the internal deferred transaction queue structures and the replication system catalogs that track outstanding asynchronous RPC calls. Because no APPS-synonym tables are documented, no business data tables are implicated; all access is confined to internal Oracle-maintained objects. Administrators and developers should therefore not expect this package to read or write EBS operational data directly.

Usage Notes

DBMS_ASYNCRPC_PUSH is referenced by seven other packages as recorded in the ETRM metadata: DBMS_ASYNCRPC_PUSH itself (internal self-reference), DBMS_DEFER_REPCAT, DBMS_DEFER_SYS_DEFINER, DBMS_DEFER_SYS_PART1, DBMS_OFFLINE_RGT_INTERNAL, DBMS_REPCAT_SNA_UTL, and DBMS_REPCAT_UTL and DBMS_REPCAT_UTL3. This dependency graph places the package squarely within the Advanced Replication and deferred transaction family. It is not invoked from EBS forms and is not associated with a concurrent program in the standard E-Business Suite. Custom code should never call it directly. DBAs troubleshooting replication or deferred RPC delivery issues may encounter it in dependency traces, but remediation should follow Oracle-supported replication diagnostics rather than direct manipulation of this package.

PACKAGE: SYS.DBMS_ASYNCRPC_PUSH 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASYNCRPC_PUSH, status:VALID,
PACKAGE BODY: SYS.DBMS_ASYNCRPC_PUSH 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_ASYNCRPC_PUSH, status:VALID,
PACKAGE: SYS.DBMS_ASYNCRPC_PUSH 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASYNCRPC_PUSH, status:VALID,
PACKAGE BODY: SYS.DBMS_ASYNCRPC_PUSH 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_ASYNCRPC_PUSH, status:VALID,
PACKAGE: SYS.DBMS_DEFER_QUERY_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_QUERY_UTL, status:VALID,
VIEW: SYS.DEFTRANDEST 12.2.2
owner:SYS, object_type:VIEW, object_name:DEFTRANDEST, 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_DEFER_SYS 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_SYS, status:VALID,
PACKAGE: SYS.DBMS_DEFER_SYS 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_SYS, status:VALID,
PACKAGE: SYS.DBMS_ASYNCRPC_PUSH 12.2.2
PACKAGE: SYS.DBMS_ASYNCRPC_PUSH 12.1.1
PACKAGE: SYS.DBMS_DEFER_QUERY_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_QUERY_UTL, status:VALID,
VIEW: SYS.DEFTRANDEST 12.1.1
owner:SYS, object_type:VIEW, object_name:DEFTRANDEST, status:VALID,
PACKAGE: SYS.DBMS_DEFER 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_RGT_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_RGT_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_RGT_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_RGT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_DEFER 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_SYS_PART1 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_SYS_PART1, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_SYS_PART1 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_SYS_PART1, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_SYS_DEFINER 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_SYS_DEFINER, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_SYS_DEFINER 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_SYS_DEFINER, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SNA_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SNA_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL3 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL3 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL3, 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_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_ASYNCRPC_PUSH 12.2.2
TABLE: SYSTEM.REPCAT$_EXTENSION 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_EXTENSION, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL, status:VALID,
PACKAGE: SYS.DBMS_LOCK 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOCK, status:VALID,
TABLE: SYSTEM.REPCAT$_EXTENSION 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_EXTENSION, status:VALID,
PACKAGE BODY: SYS.DBMS_ASYNCRPC_PUSH 12.1.1
PACKAGE: SYS.DBMS_LOCK 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOCK, status:VALID,
TABLE: SYSTEM.DEF$_DESTINATION 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:DEF$_DESTINATION, status:VALID,
TABLE: SYSTEM.DEF$_DESTINATION 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:DEF$_DESTINATION, 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: SYS.DBMS_SYSTEM 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYSTEM, status:VALID,
PACKAGE: SYS.DBMS_SYSTEM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYSTEM, 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.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
SYS.DBMS_DEFER_REPCAT dependencies on DBMS_ASYNCRPC_PUSH 12.1.1