INV-0024: Forecast Cost Finish date is earlier than Forecast Cost Start date

Products

• Clarity PPM On Premise
• Clarity PPM SaaS
• Clarity FedRAMP

Issue/Introduction

Users are unable to update anything on an Investment Properties page.Regardless of what data is being changed, the changes revert back and the following Toast message is returned:
INV-0024: Forecast Cost Finish date is earlier than Forecast Cost Start date

The app-ca.log file shows the following error:

ERROR 2025-07-17 20:17:19,027 [http-nio-8080-exec-257] rest.validation (clarity:myuser:mysession:PPM_REST_API) (2a952d60-3fb3-4dcf-b1ee-ea11e8a509e0) ExceptionInfo ::  Could not update resource. Resource name: custCustProgramss. Error code: projmgr.FORECAST_COST_DATE_SEQUENCE Error message: INV-0024: Forecast Cost Finish date is earlier than Forecast Cost Start date

Environment

Clarity 16.3.3

Cause

The Forecast Cost Start date equals the Forecast Cost Finish date

Resolution

Please run the following query:

select fcst_cst_start, fcst_cst_finish from prj_projects where prid = <internal 5 million project/investmet id>

The fcst_cst_finish value must be higher than the fcst_cst_start value, otherwise the error is returned.
The fcst_cst_start date should equal the Investment Start date and the fcst_cst_finish should equal the Investment Finish date

In order to fix, please proceed as follows:

• Ensure the Investment Start and the Finish Date are different
• Go to the Financial Plans of the project and create a new financial plan and set it as Plan of record.
• This will update the prj_projects table appropriately
• Delete the dummy cost plan created in Step2