Unable To Run "Audit Data - All" Report With Error "Invalid Identifier"

(Doc ID 2342261.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.5 and later
Primavera P6 Enterprise Project Portfolio Management - Version 17.7 and later
Information in this document applies to any platform.

Symptoms

Unable to run "Audit Data - All" seeded report

ERROR
P6 Web Error: Errors have been encountered while running the report. To resolve, contact your administrator.

BI Publisher error: "ORA-00904: "AUDIT_DATE": invalid identifier".

STEPS
The issue can be reproduced at will with the following steps:

  1. Login to P6 Web
  2. Browse to Reports-->Audit-->Audit Data - All
  3. Enter Parameters, then click Run, got error above.

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot run the report with data shown

Cause

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 hundreds of Community platforms