Clarity: The Remaining Cost value in Hierarchy portlet isn't showing correct aggregate value

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

Description:

Program Remaining Cost value does not show the correct value.

We discovered that 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.

I discovered that the alphabetical first child investment was also the first investment that I 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)

This behavior can be seen in the customer's data set.

This behavior cannot be replicated in a generic, seed data set.

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)

Solution:

Workaround:
None.

Status/Resolution:
Resolved in Clarity 12.1.3
Resolved in Clarity 12.0.6 Generic Patch. Reference TEC522707.
Resolved in Clarity 12.1.1 Generic Patch. Reference TEC553491.

Keywords: CLARITYKB, CLRT-60076, clarity12resolved, clarity1213resolved.