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:
- Create a cost plan, add a few line items and populate some non-zero values into some cells, hit the Save button
- Set this plan as the Plan of Record, submit it for approval
- Navigate to the Financial Plans > Budget Plans sub tab, find the new budget plan that is in submitted state
- 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
- Check the slice data
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.
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.