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


Article ID: 49632


Updated On:


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



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.


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.


Release: ESPCLA99000-13.2-Clarity-Extended Support Plus