Search Results dbms_defergen_priority

Overview

SYS.DBMS_DEFERGEN_PRIORITY is an Oracle-supplied PL/SQL package that resides in the SYS schema and holds a VALID status in the E-Business Suite environment. It is a member of the DBMS_DEFERGEN family of packages, which Oracle provides to support deferred transaction generation within the Advanced Replication infrastructure. In the EBS 12.1.1 and 12.2.2 architectures, deferred remote procedure calls and multi-master replication play a background role in keeping distributed database configurations synchronized. DBMS_DEFERGEN_PRIORITY is the component responsible for determining and ordering the priority of deferred transactions as they are queued for propagation to destination sites.

The package is not an application-level API. It is an internal utility invoked by DBMS_DEFERGEN, the primary package in the deferred transaction generation stack. Because it is owned by SYS and classified as OTHER in the ETRM repository, it should be treated strictly as Oracle internal plumbing rather than as a supported extension point for EBS customizations.

Key Procedures and Functions

The ETRM metadata for this object documents zero procedures or functions. This is consistent with the package being an internal implementation detail of the replication subsystem. Oracle does not publish a supported callable interface for DBMS_DEFERGEN_PRIORITY.

Functionally, the package supplies the priority evaluation logic consumed by its parent, DBMS_DEFERGEN. In Oracle replication, each deferred transaction can carry a priority weight, and higher-priority transactions are dequeued and pushed ahead of lower-priority ones. DBMS_DEFERGEN_PRIORITY encapsulates the rules and helpers that assign or resolve that ordering. Because no parameter lists are documented, no supported procedure signatures should be assumed or referenced in custom code.

Tables Accessed

The ETRM excerpt does not enumerate any tables accessed through APPS synonyms. This is expected: the package is a SYS-owned replication utility and therefore operates against the underlying replication dictionary objects maintained directly in the SYS schema, such as the DEF$_ transaction queue structures and related metadata. These objects are internal to the database and are not surfaced through EBS application synonyms. EBS application tables are not read or written by this package.

Usage Notes

DBMS_DEFERGEN_PRIORITY is referenced by exactly one other package, SYS.DBMS_DEFERGEN, according to the dependency information in the ETRM repository. SYS.DBMS_DEFERGEN_PRIORITY also references the SYS STANDARD package, reflecting ordinary PL/SQL runtime dependencies. It is invoked indirectly whenever the deferred transaction generation process evaluates transaction priority.

Typical invocation paths include scheduled replication jobs, the push and purge background processes that move deferred transactions between EBS database sites, and any database-level job that drives DBMS_DEFERGEN. In an EBS context this activity is largely invisible to the application user and is governed by the DBA team rather than by functional or technical EBS developers.

Custom EBS code should never call DBMS_DEFERGEN_PRIORITY directly. Because the package is undocumented, unsupported, and subject to change with Oracle database patches and upgrades, direct invocation risks breakage during maintenance. Administrators troubleshooting replication latency or priority inversion should instead review the configuration and logs of the DBMS_DEFERGEN subsystem and consult Oracle Support. The presence of this package with a VALID status indicates only that it is compiled and available, not that it carries an exposed interface for application use.

PACKAGE: SYS.DBMS_DEFERGEN_PRIORITY 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_PRIORITY, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_PRIORITY 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_PRIORITY, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_PRIORITY 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_PRIORITY, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_PRIORITY 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_PRIORITY, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_PRIORITY 12.1.1
PACKAGE: SYS.DBMS_DEFERGEN_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_UTIL, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_PRIORITY 12.2.2
PACKAGE: SYS.DBMS_DEFERGEN_PRIORITY 12.1.1
PACKAGE BODY: SYS.DBMS_DEFERGEN_PRIORITY 12.2.2
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 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
TABLE: SYSTEM.REPCAT$_PRIORITY_GROUP 12.2.2
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_PRIORITY_GROUP, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
TABLE: SYSTEM.REPCAT$_PRIORITY_GROUP 12.1.1
owner:SYSTEM, object_type:TABLE, object_name:REPCAT$_PRIORITY_GROUP, status:VALID,
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
SYS.DBMS_DEFERGEN_PRIORITY dependencies on DBMS_DEFERGEN_PRIORITY 12.2.2
PACKAGE: SYS.DBMS_ASSERT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
PACKAGE: SYS.DBMS_ASSERT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
SYS.DBMS_DEFERGEN_PRIORITY dependencies on DBMS_DEFERGEN_PRIORITY 12.1.1
SYS.DBMS_DEFERGEN dependencies on DBMS_DEFERGEN_PRIORITY 12.2.2
SYS.DBMS_DEFERGEN dependencies on DBMS_DEFERGEN_PRIORITY 12.1.1
SYS.DBMS_DEFERGEN_PRIORITY dependencies on DBMS_DEFERGEN 12.1.1
SYS.DBMS_DEFERGEN_PRIORITY dependencies on DBMS_DEFERGEN 12.2.2
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,