Modifying the Out of the Box stages under lookup INV_TYPE may cause the Project Status List Report to not group by stage correctly.
This happens when you add a new parent level under INV_PROJECT_TYPE and then inactivate the OOTB values under INV_PROJECT_TYPE
Steps to Reproduce:
Lookup Value ID Description
Project Stage 1 Ideadtion and Initiation PROJECT_LIFECYCLE_STAGE_1 Project Stage 1 Ideadtion and Initiation
Project Stage 2. Plan and Analysis PROJECT_LIFECYCLE_STAGE_2 Project Stage 2. Plan and Analysis
Project Stage 3. Design PROJECT_LIFECYCLE_STAGE_3 Project Stage 3. Design
Project Stage 4. Build and Test PROJECT_LIFECYCLE_STAGE_4 Project Stage 4. Build and Test
Project Stage 5. Deploy PROJECT_LIFECYCLE_STAGE_5 Project Stage 5. Deploy
Project Stage 6. Close PROJECT_LIFECYCLE_STAGE_6 Project Stage 6. Close
6. Create status reports for several projects
7. Assign a variety of Stages to different projects. Make sure to include several of these new ones.
8. Run Load Data Warehouse job
9. Go to Advanced Reporting or Reports and jobs and select Project Status Report List
Expected Results: The report groups by stage correctly.
Actual Results: The stages are jumbled and repeated throughout the report.
Reported as defect DE60374.
Release : 15.9.1
Component : CA PPM SAAS JASPERSOFT
Fixed in 15.9.2