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:

1. Log into Clarity as an administrator user
   
   
2. Home > Products > click 'New' button
   
   Create a new 'Product' Investment (myProduct99)
   
   
3. Projects > click 'New' button
   
   Create a new 'Project' Investment (myProject11)
   
   
4. Products > myProduct99 > Hierarchy Tab > click 'Add Child' button
   
   Select 'myProject11'
   
   

   <Please see attached file for image>

   
   
   
5. Execute INV_FLAT_HIERARCHIES Query
   
   

   <Please see attached file for image>

   
   
   
6. Products > myProduct99 > Hierarchy Tab > select 'myProject11's
   
   
7. Click 'Remove' button
   
   Yellow Alert: Are you sure you want to remove the following investments? (myProject11)
   Click 'Yes' button
   
   
8. Execute INV_FLAT_HIERARCHIES Query

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.

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component: