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:

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.

Cause

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