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 JUNE 17, 2018

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

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

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

STEPS

The issue can be reproduced sometimes with the following steps:
1. A user initiates a job service (Example: scheduling a project)
2. Query PRMAUDIT table. It is found that a different user, who has nothing to do with this job service, is audited to the PRM_USER_NAME field.
3. Review the Update User column in P6 Application (such as the activity view), and notice that it is an user who doesn't have access to make changes to the project/activity

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.