My Oracle Support Banner

The ADMUSER.RT_UDFVALUE Trigger Populates the "Latest Update" Column When Any UDF Values Are Updated (Doc ID 2937014.1)

Last updated on JULY 06, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 21.12 to 21.12.13.0 [Release 21.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 21.9 to 21.12.13.0 [Release 21.9 to 21.12]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

The ADMUSER.RT_UDFVALUE trigger populates the "Latest Update" column when any UDF values are updated.  In addition, P6 Professional users may receive the following error:

PRMDV-2167-E
PRM DBAccess Error
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at admuser.rt_udfvalue line 15
ORA-04088: error during execution of trigger admuser.rt_udfvalue

EXPECTED BEHAVIOR

The "Latest Update" column should not get updated when a UDF value is updated.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.