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

book

Article ID: 49986

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

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>

    Figure 1

  5. Execute INV_FLAT_HIERARCHIES Query

    <Please see attached file for image>

    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.

Environment

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

Attachments

1558710167690000049986_sktwi1f5rjvs16rrg.gif get_app
1558710165697000049986_sktwi1f5rjvs16rrf.gif get_app
1558535172585TEC556316.zip get_app