Error: "ORA-00904: "TASKX"."BASELINELATEFINISHDATE": Invalid Identifier" When Attempting to Run a Report After Upgrading P6 EPPM to r8.3 or Later

(Doc ID 2350972.1)

Last updated on JANUARY 26, 2018

Applies to:

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


When attempting to run a report, the following error occurs after upgrading the database to r8.3 and later and when using a report referencing the TASKX.BASELINELATEFINISHDATE column:

Error: ORA-00904: "TASKX"."BASELINELATEFINISHDATE": invalid identifier

The issue can be reproduced at will with the following steps:
     1. Create an 8.2.12 EPPM database - this includes the BASELINELATEFINISHDATE field in taskx table
     2. Run Migrate.bat utility from the 15.2.13 patchset
     3. Notice after migration is complete, open migrated database and expand taskx table columns to see BASELINELATEFINISHDATE is missing


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