Remaining Cost in Hierarchy portlet isn't showing correct aggregate value in 12.1

book

Article ID: 50601

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Program Remaining Cost value does not show the correct value. The Remaining Cost is being calculated as a factor of the number of children investments and uses the remaining cost for the alphabetical first child investment in the program.

The alphabetical first child investment was also the first investment created; so that is why it was using that one in the calculation. The behavior is picking the first child investment created (based on created date/time, regardless of the name/id). 

The steps below are GENERIC in nature. You can create NEW Child Investments and a NEW Program and replicate the issue on this data set ; it is repeatable with this customer data set.

Prerequisites:

Create 3 projects in the following order:

  1. Investment Name begin with letter C - Planned Cost = 5,000,000.00
  2. Investment Name begin with letter M - Planned Cost = 4,000,000.00
  3. Investment Name begin with letter P - Planned Cost = 2,000,000.00

Steps to Reproduce:

  1. Create a Program

  2. Navigate to Hierarchy Tab > Financial Rollup

  3. Add 1 Child Investment:

    Investment Name: begin with letter M
    Planned Cost = 4,000,000.00
    Actual Cost = 0.00
    Remaining Cost = 4,000,000.00
    (Investment should appear as 100% allocated to this program, if not change to 100%)

  4. View the Hierarchy Financial Rollup and see that the Program Financial Rollup Values reflect the amounts for this one investment

  5. Add a 2nd Child Investment:

    Investment Name: begin with letter P (alphabetically AFTER M)
    Planned Cost = 2,000,000.00
    Actual Cost = 0.00
    Remaining Cost = 2,000,000.00
    (Investment should appear as 100% allocated to this program, if not change to 100%)

  6. View the Hierarchy Financial Rollup and see that the Program Financial Rollup Values

    *** Planned Cost is ok, Remaining Cost shows 8,000,000.00
    (which equates to 2 x 4,000,000.00)

  7. Add a 3rd Child Investment:

    Investment Name: begin with letter C (alphabetically BEFORE M)
    Planned Cost = 5,000,000.00
    Actual Cost = 0.00
    Remaining Cost = 5,000,000.00
    (Investment should appear as 100% allocated to this program, if not change to 100%)

  8. View the Hierarchy Financial Rollup and see that the Program Financial Rollup Values
    *** Planned Cost is ok, Remaining Cost shows 15,000,000.00
    (which equates to 3 investments x 5,000,000.00)

Cause

Caused by: CLRT-60076

Environment

Release: Clarity 12.1
Component: Clarity Financials

Resolution

Resolved in Clarity 12.1.3
Resolved in Clarity 12.0.6 Generic Patch.
Resolved in Clarity 12.1.1 Generic Patch. 

Workaround: None.