search cancel

Data discrepancy in table "odf_ssl_cst_dtl_cost" For Cost Plans

book

Article ID: 239074

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Slice details for Cost Plan Detail rows in table odf_ssl_cst_dtl_cost are inconsistent with the values shown in UI. 

Ex:- Take an Annual Cost Plan starting from 2023 - 2025. Ideally the table should contain slice details from 01-01-2023 - 01-01-2024, 01-01-2024 - 01-01-2025 however there is only a single row from 01-01-2023 - 01-01-2025.

Cause

Steps to Reproduce:- 

  1. Login to Clarity. Navigate to New UI.
  2. Create a new Annual Cost plan on Project/Idea using the "Financials" Module. 
  3. Instead of populating each column for the year, just populate Totals column with the value of Cost for a Cost Plan Detail Row.

Expected Results :- Ui Shows values for all the years and odf_ssl_cst_dtl_cost should have rows for each year.

Actual Results :- UI Shows values for all the years and odf_ssl_cst_dtl_cost has only a single rows from the start of the cost plan to the end of the cost plan.

Environment

Release : 16.0.1

Component : Clarity Financial Management

Resolution

This is working as designed. Users should populate the cost values for each year/month based on the Cost Plan Type. Populating the Totals column will take the cost curve for the whole period of the cost plan.