The User Audit Fields UPDATE_USER, PRM_USER_NAME, etc. Show Incorrect User ID
(Doc ID 2284192.1)
Last updated on APRIL 14, 2020
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.8 and later
Information in this document applies to any platform.
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.
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.
The PRM_USER_NAME field of table PRMAUDIT is audited with the correct information of a user who initiates the job service.
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.
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