User Name Audit Fields in the PRMAUDIT and JOBSVC Tables Show an Unexpected User ID
(Doc ID 2284192.1)
Last updated on JANUARY 23, 2024
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 8.3 and laterPrimavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.2.0.0 and later
Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
Scheduled and on-demand Job Service jobs result in an unexpected user name in the PRM_USER_NAME field of the PRMAUDIT database table, the UPDATE_USER field of the JOBSVC table, and the Update User field in some P6 application views.
EXPECTED BEHAVIOR
The PRMAUDIT and JOBSVC tables and P6 application view should reflect the account name of the user who initiated the job.
The issue can sometimes be reproduced with the following steps:
1. A user initiates a job (ex. Scheduling a project).
2. Query the PRMAUDIT table, note that one of the reported user names 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 user name displayed.
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! |