CA PPM Project Status reports displaying incorrectly

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

After adding a value to the INV_TYPE table, there appears to be some issues with how projects are displaying in reports. The "project status report list" report is showing the stage progress bar incorrectly. For "Phase-0" its showing the green box at the end of the progress bar rather than at the start which is where it should be for this phase.
Example:

<Please see attached file for image>

Additionally the "project status summary" report is showing multiple groups for each phase rather than one group for each phase.

Cause

The data in Data Warehouse was not properly in sync as it should have been.

Environment

CA PPM 15.1 and above

Resolution

After running the FULL Data Warehouse Load, both reports are now displaying properly.