My Oracle Support Banner

Why is PRIVUSER Periodically Executing an Update Statement Against the PREFER Table which Does Not Actually Update Any Rows? (Doc ID 2426062.1)

Last updated on OCTOBER 02, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Information in this document applies to any platform.

Goal

Why is an audit of the PREFER table showing the following update statement by PRIVUSER from the P6 Web Server and why is it not actually updating any rows?

update ADMUSER.prefer set ts_approve_user_id = null where (ts_approve_user_id = XX)
-- Where 'XX" is a user_id that does NOT exist in the USERS table. --
 

Solution

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

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


In this Document
Goal
Solution
References


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