Search Results dbms_defergen_audit

Overview

SYS.DBMS_DEFERGEN_AUDIT is an Oracle-supplied PL/SQL package that forms part of the deferred transaction (deferred remote procedure call) infrastructure underpinning Oracle Advanced Replication and multi-master replication. In Oracle E-Business Suite 12.1.1 and 12.2.2, this package operates exclusively within the SYS schema and carries a status of VALID. Its classification in the ETRM repository is OTHER, reflecting that it is an internal database kernel utility rather than a public, documented applications API.

The package provides the auditing and diagnostic layer for the deferred transaction queue generation mechanisms. It works in tandem with related internal packages to record, interrogate, and report on the state of deferred transactions as they are generated, propagated, and resolved between replication sites. Business functionality in EBS that depends on replication—such as multi-org data synchronization, multi-master deployments, and certain mobile or distributed application configurations—relies indirectly on this package to maintain integrity and traceability of deferred queue activity.

Key Procedures and Functions

The ETRM documentation records the package as containing zero documented procedures or functions accessible through the repository metadata. This is consistent with the package's internal nature: DBMS_DEFERGEN_AUDIT exposes implementation-level routines that are called by sibling internal packages rather than by application developers or end users.

Because the documented procedure list is empty, no public parameter signatures can be cited. The package's functional role is inferred from its dependency graph, which places it squarely within the DBMS_DEFERGEN family—the machinery responsible for generating deferred transaction entries in the replication queue. Its audit-oriented purpose is to support inspection and reporting of that generation activity, not to initiate it.

Tables Accessed

The ETRM metadata does not enumerate specific tables accessed through APPS synonyms for this package. This omission is expected: DBMS_DEFERGEN_AUDIT resides in SYS and operates against Oracle replication catalog tables—such as the deferred transaction queue and associated system views—rather than against EBS application tables owned by schemas like AP, GL, or INV. EBS application code therefore does not directly read or write the tables this package touches; interaction occurs only through the lower-level replication services that Oracle Database provides.

Usage Notes

DBMS_DEFERGEN_AUDIT is not intended for direct invocation from Oracle EBS forms, concurrent programs, or custom PL/SQL. It is an internal dependency, referenced by three packages according to the ETRM dependency data:

SYS.DBMS_DEFERGEN — the primary deferred transaction generation package
SYS.DBMS_DEFERGEN_AUDIT — self-referencing for internal calls
SYS.DBMS_DEFERGEN_INTERNAL and SYS.DBMS_DEFERGEN_RESOLUTION — supporting internal and resolution-layer packages

It in turn references SYS.DBMS_DEFERGEN and SYS.STANDARD. Administrators and DBAs encountering this object during EBS troubleshooting should treat it as a protected system component: its VALID status should be maintained, and any investigation of replication defects should proceed through supported Oracle replication diagnostics rather than by calling these routines directly. Custom code must never invoke DBMS_DEFERGEN_AUDIT, as Oracle does not guarantee its interface across releases or patches.

PACKAGE: SYS.DBMS_DEFERGEN_AUDIT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_AUDIT, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_AUDIT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_AUDIT, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_AUDIT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_AUDIT, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_AUDIT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_AUDIT, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_AUDIT 12.1.1
PACKAGE BODY: SYS.DBMS_DEFERGEN_RESOLUTION 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_RESOLUTION, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_RESOLUTION 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_RESOLUTION, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_UTIL, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_AUDIT 12.2.2
PACKAGE BODY: SYS.DBMS_DEFERGEN 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_UTIL, status:VALID,
TABLE: SYSTEM.REPCAT$_AUDIT_ATTRIBUTE 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_AUDIT_ATTRIBUTE, status:VALID,
TABLE: SYSTEM.REPCAT$_AUDIT_ATTRIBUTE 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_AUDIT_ATTRIBUTE, status:VALID,
TABLE: SYSTEM.REPCAT$_AUDIT_COLUMN 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_AUDIT_COLUMN, status:VALID,
TABLE: SYSTEM.REPCAT$_GROUPED_COLUMN 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_GROUPED_COLUMN, status:VALID,
TABLE: SYSTEM.REPCAT$_GROUPED_COLUMN 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_GROUPED_COLUMN, status:VALID,
TABLE: SYSTEM.REPCAT$_AUDIT_COLUMN 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_AUDIT_COLUMN, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
TABLE: SYSTEM.REPCAT$_REPCOLUMN 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_REPCOLUMN, status:VALID,
TABLE: SYSTEM.REPCAT$_REPCOLUMN 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_REPCOLUMN, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_AUDIT 12.2.2
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_AUDIT 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
TABLE: SYS.COL$ 12.2.2
owner:SYS, object_type:TABLE, object_name:COL$, status:VALID,
TABLE: SYS.COL$ 12.1.1
owner:SYS, object_type:TABLE, object_name:COL$, status:VALID,
SYS.DBMS_DEFERGEN_RESOLUTION dependencies on DBMS_DEFERGEN_AUDIT 12.1.1
SYS.DBMS_DEFERGEN_INTERNAL dependencies on DBMS_DEFERGEN_AUDIT 12.2.2
SYS.DBMS_DEFERGEN_RESOLUTION dependencies on DBMS_DEFERGEN_AUDIT 12.2.2
SYS.DBMS_DEFERGEN dependencies on DBMS_DEFERGEN_AUDIT 12.2.2
SYS.DBMS_DEFERGEN_AUDIT dependencies on DBMS_DEFERGEN_AUDIT 12.2.2
SYS.DBMS_DEFERGEN dependencies on DBMS_DEFERGEN_AUDIT 12.1.1
SYS.DBMS_DEFERGEN_INTERNAL dependencies on DBMS_DEFERGEN_AUDIT 12.1.1
SYS.DBMS_DEFERGEN_AUDIT dependencies on DBMS_DEFERGEN_AUDIT 12.1.1
PACKAGE: SYS.DBMS_ASSERT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
PACKAGE: SYS.DBMS_ASSERT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
TABLE: SYS.OBJ$ 12.2.2
owner:SYS, object_type:TABLE, object_name:OBJ$, status:VALID,
TABLE: SYS.OBJ$ 12.1.1
owner:SYS, object_type:TABLE, object_name:OBJ$, status:VALID,
TABLE: SYS.USER$ 12.2.2
owner:SYS, object_type:TABLE, object_name:USER$, status:VALID,
TABLE: SYS.USER$ 12.1.1
owner:SYS, object_type:TABLE, object_name:USER$, status:VALID,
SYS.DBMS_DEFERGEN_AUDIT dependencies on DBMS_DEFERGEN 12.2.2
SYS.DBMS_DEFERGEN_AUDIT dependencies on DBMS_DEFERGEN 12.1.1