Clarity: Updating a Submitted Budget Plan Cost to Zero Is Not Reflected in 'ODF_SSL_CST_DTL_COST' Table

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

Description:

In the detailed budget plan if you have a submitted Budget with a cost value of say 200 then proceed to edit the Budget plan cost value to zero, the corresponding slice value in 'ODF_SSL_CST_DTL_COST' table does not get updated to reflect the change.

Please note that the FIN_COST_PLAN_DETAILS table however does get updated.

Steps to Reproduce:

  1. Create a cost plan, add a few line items and populate some non-zero values into some cells, hit the Save button

  2. Set this plan as the Plan of Record, submit it for approval

  3. Navigate to the Financial Plans > Budget Plans sub tab, find the new budget plan that is in submitted state

  4. Set the budget plan to Edit Mode, change the values for a few cells to zero, such as changing $500 for December 2011 to 0.00, Save

  5. Check the slice data

example query:

select * from odf_ssl_cst_dtl_cost where prj_object_id in (select id from fin_cost_plan_details where plan_id=?)
-- where ? is the internal plan id for the plan visible from the plan URL

Expected Result: The slice table should not have any rows where the value entered equals zero (0).

Actual Result: The slice table still has a record and the value reflects the earlier value for $500.

Solution:

The slice table is not intended to store zero-value cell entries and therefore the existing record with the prior, non-zero value should have been deleted.

This a variation of the issue documented in KB TEC558961 : Clarity: Cost Plan Aggregate View Not Updated When 0 Is Saved From Flat View

This issue is resolved in the following versions:

Resolved in Clarity 12.1.1 Generic Patch. Reference TEC553491
Resolved in Clarity 12.1.2 Generic Patch. Reference TEC572267
Resolved in Clarity 12.1.3
Resolved in Clarity 13.0.1
Resolved in Clarity 13.1.0

Keywords: CLARITYKB, CLRT-65121, CLRT-64765, clarity12resolved, clarity1211resolved, clarity1212resolved, clarity1213resolved, clarity13resolved, clarity1301resolved, null, empty, delete, remove, wiped.