My Oracle Support Banner

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 later
Primavera 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!

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