Description:
We encountered a similar issue to the one described in TEC553813. We are using Clarity 12.1.0 and the records in the INV_FLAT_HIERARCHIES table are not removed when the child investment is removed from the hierarchy. We do not use 'Programs', instead we use 'Products' for our Hierarchy and when we have 'Project' Investments in the hierarchy and remove them, and the record is not removed from the table.
Steps to Reproduce:
<Please see attached file for image>
<Please see attached file for image>
Expected Result: The child record should be removed
Actual Result: The child record remains
Solution:
Workaround:
None.
Status/Resolution:
Resolved in Clarity 13.2
Keywords: CLARITYKB, CLRT-64873, clarity13resolved, clarity132resolved, pma, hierarchy, hierarchical.