My Oracle Support Banner

Unable To Run "Audit Data - All" Report With Error "Invalid Identifier" (Doc ID 2342261.1)

Last updated on MARCH 26, 2019

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

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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