My Oracle Support Banner

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 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

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
-----------------------
Error: ORA-00904: "TASKX"."BASELINELATEFINISHDATE": invalid identifier


STEPS TO DUPLICATE
-----------------------
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

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
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.