Results for “dbms_apply_handler_adm”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
SYS.DBMS_APPLY_HANDLER_ADM is an Oracle-supplied PL/SQL package that forms part of the internal infrastructure supporting Oracle Streams and Advanced Replication apply processing. Within the Oracle E-Business Suite environment — whether on release 12.1.1 or 12.2.2 — this package is owned by the SYS schema and is documented with a status of VALID. Its purpose is administrative rather than business-facing: it manages the registration, configuration, and lifecycle of apply handlers that are attached to apply processes. Apply handlers are the programmable hooks that allow custom PL/SQL logic to execute when replicated or captured messages are applied at a destination database.
The package is classified under the ETRM API classification OTHER, indicating that it is not an EBS business API but rather a kernel-level database component surfaced for dependency tracking and impact analysis. It does not serve a specific EBS module such as Order Management or Payables; instead it underpins the data propagation mechanisms that EBS relies upon when Advanced Replication or Streams-based replication is configured for multi-tier deployments, reporting databases, or data synchronisation between instances.
Key Procedures and Functions
The ETRM 12.2.2 metadata records zero documented procedures or functions for SYS.DBMS_APPLY_HANDLER_ADM. This is typical of internal Oracle packages whose callable interfaces are not published in the EBS reference repository. The package is documented primarily through its dependency relationships rather than through an enumerated API surface.
Functionally, the package belongs to the DBMS_APPLY_* family of administrative packages. Packages in this family are used to create, alter, enable, disable, and drop apply handlers, and to associate handler logic with specific apply processes. Because no individual subprograms are documented in the ETRM extract, no signatures or parameter lists should be assumed. Any invocation should be validated against the Oracle Database version's official PL/SQL documentation rather than against EBS-specific references.
Tables Accessed
The ETRM metadata does not record any tables accessed by this package via APPS synonyms. This confirms that DBMS_APPLY_HANDLER_ADM does not read or write EBS application tables. Any persistent state it manipulates resides in Oracle's internal data dictionary and replication metadata — principally the apply-handler definitions maintained by the Streams/Advanced Replication engine — and is managed through the companion package SYS.DBMS_APPLY_ADM rather than through direct DML against application objects.
The absence of APPS-synonym table references is a strong indicator that the package is purely administrative and does not participate in transactional EBS data flow.
Usage Notes
SYS.DBMS_APPLY_HANDLER_ADM is not invoked by EBS forms, concurrent programs, or standard application code. Its dependency footprint confirms this: it references only SYS.STANDARD, and it is referenced solely by SYS.DBMS_APPLY_ADM and by itself. It does not appear in the call graph of any APPS-layer object.
In practice, the package is exercised only during the configuration or maintenance of Streams and Advanced Replication environments — for example, when a DBA or replication administrator registers a custom apply handler at a destination site. In an EBS 12.1.1 or 12.2.2 installation, such scenarios arise when replication is used for reporting offload, disaster recovery, or cross-instance synchronisation.
Because the package is owned by SYS and is undocumented at the subprogram level in ETRM, custom code should never call it directly. Any dependency on it should be treated as an infrastructure concern, and changes to replication configuration should be performed only under Oracle's documented procedures, with full regard for the proprietary and confidential nature of the component.
-
VIEW: SYS.DBA_APPLY 12.1.1
-
VIEW: SYS.DBA_APPLY 12.2.2
-
PACKAGE: SYS.DBMS_APPLY_ADM 12.2.2
-
PACKAGE: SYS.DBMS_APPLY_ADM 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1