Clarity: Product Investment Hierarchy: Records remain in the INV_FLAT_HIERARCHIES table when removing a Child Project Investment from the Product Hierarchy

Document ID : KB000049986
Last Modified Date : 14/02/2018
Show Technical Document Details

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'

    Figure 1

  5. Execute INV_FLAT_HIERARCHIES Query

    Figure 2

  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.

File Attachments:
TEC556316.zip