When changing Hierarchy for Program and Projects there is a record for a link left in table INV_FLAT_HIERARCHIES
Steps to Reproduce:
- Create 3 new projects and 2 new programs and set up following HIERARCHY
Program1 | |-- project child1 | |-- project child2 | |-- project child3
- project child2 ==> tab: Hierarchy ==> sub tab: Parents - remove "project child1" as parent
- project child2 ==> tab: Hierarchy ==> sub tab: Parents - add new parent "Program2"
Program1 | |-- project child1 Program2 | |-- project child2 | |-- project child3
Expected Result: In table INV_FLAT_HIERARCHIES records for the link from "Program1" to "project child3" because they are no longer in the hierarchy
Actual Result: In table INV_FLAT_HIERARCHIES is remains a records for the link from "Program1" to "project child3" even though these are not linked in the UI anymore
This dangling orphan record affects any Clarity calculation that uses the flat investment hierarchy table to aggregate data for a master project/program.
Resolved in Clarity 12.0.6 Generic Patch. Reference TEC522707
Resolved in Clarity 12.1.0
Resolved in Clarity 12.1.1 Generic Patch. Reference TEC553491
Resolved in Clarity 12.1.3
Resolved in Clarity 13.0.1
Keywords: CLARITYKB, CLRT-38002, clarity12resolved, clarity1210resolved, CLRT-60984, CLRT-48499, CLRT-63316, CLRT-56440.