My Oracle Support Banner

The User Audit Fields UPDATE_USER, PRM_USER_NAME, etc. Show Incorrect User ID (Doc ID 2284192.1)

Last updated on MARCH 25, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 to 8.3.15.6 [Release 8.3]
Primavera P6 Enterprise Project Portfolio Management - Version 15.2.0.0 to 15.2.16.2 [Release 15.2]
Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 to 16.2.11.0 [Release 16.2]
Primavera P6 Enterprise Project Portfolio Management - Version 17.12.0.0 to 17.12.0.0 [Release 17.12]
Primavera P6 Enterprise Project Portfolio Management - Version 8.4.0.0 to 8.4.15.3 [Release 8.4]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

After one user submits a job service (Example: scheduling a project), a different user is audited to the field PRM_USER_NAME in table PRMAUDIT.

Or

A view in the P6 Application (such as the Activity view) shows an Update User who does not have access to make changes to the project/activity. The related table shows the incorrect UPDATE_USER value.


EXPECTED BEHAVIOR

The PRM_USER_NAME field of table PRMAUDIT is audited with the correct information of a user who initiates the job service.

And

The P6 Application (such as the activity view) shows the correct Update User who has access to make changes to the project/activity. The UPDATE_USER field shows correct user Id of the user who modified this object.

The issue can be reproduced sometimes with the following steps:
   1. A user initiates a job service (Example: scheduling a project).
   2. Query the PRMAUDIT table, note that a different user (who has nothing to do with the job in Step 1) is shown in the PRM_USER_NAME field of the relevant audit record.
   3. Review the Update User column in a view, note the reported incorrect user.

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!


In this Document
Symptoms
Changes
Cause
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.