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 APRIL 06, 2023

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

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