My Oracle Support Banner

Views PXRPTUSER.AUDIT_PROJECT and PXRPTUSER.AUDIT_ALL Are Invalid and Fail to Recompile After Upgrading P6 EPPM to Version 19.12 or Later (Doc ID 2773886.1)

Last updated on JANUARY 29, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading P6 EPPM version 19.12 or later, the views PXRPTUSER.AUDIT_PROJECT and PXRPTUSER.AUDIT_ALL are reported as invalid, and attempting to recompile them fails with the following error.

ORA-00942: table or view does not exist

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.