A project is displayed on the project list page twice. The internal ID shown in the URL when clicking into any of the the duplicated project are the same; when querying the inv_investments table for that internal ID or project name or project code only one row is returned.
The user who last updated the project was trying to create a baseline and encountered an error displayed in a pop-up. Unfortunately the user does not remember any details as to what the error was or what was done right before getting the error. The baseline cannot be found on the project or the database so looks like it never got created.
What is causing the project to display twice and how to resolve it?
The steps to reproduce are unknown, but the query for generating the project list filtered result was retrieved from an Action Trace, the query returns two rows when it is run directly on the database. After narrowing down the tables used in the query it is observed that the PRJ_EV_HISTORY table having two records instead of one for the same project.
Release: CODFSS99000-15.3-PPM SAAS FedRAMP-Sandbox-Small Environment
A simplified query can be run to see the problem:
For additional issues caused by duplicates in the PRJ_EV_HISTORY table, please see:
KB000033258: Load Data Warehouse job fails with ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found on DWH_INV_PROJECT
KB000101876: PRJ_EV_HISTORY duplicates cause wrong data in Project Earned Value Report and Load Data Warehouse job error