Clarity: When changing Hierarchy for Program and Projects there is a record for a link left in table INV_FLAT_HIERARCHIES

book

Article ID: 50250

calendar_today

Updated On:

Products

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

Issue/Introduction

Description:

When changing Hierarchy for Program and Projects there is a record for a link left in table INV_FLAT_HIERARCHIES

Steps to Reproduce:

  1. Create 3 new projects and 2 new programs and set up following HIERARCHY

    Initial structure:
     Program1 | |-- project child1     |     |-- project child2        |        |-- project child3
  2. project child2 ==> tab: Hierarchy ==> sub tab: Parents - remove "project child1" as parent

  3. project child2 ==> tab: Hierarchy ==> sub tab: Parents - add new parent "Program2"

    New structures:
     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

Solution:
This dangling orphan record affects any Clarity calculation that uses the flat investment hierarchy table to aggregate data for a master project/program.

Status/Resolution:
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.

Environment

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