Description of Cost Plan Detail Child rows can be removed causing DWH failures

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Datawarehouse Job Failure on DWH_FIN_PLAN_DETAIL as there are NULL's for detailed_record_description column

STEPS TO REPRODUCE:
1. Login to Clarity Modern UX.
2. Open a Project which has a cost plan or create a cost plan in a project.
3. Add a Cost Plan Detail row.
4. Right click on the detail row and select "Create Detail Row". This will prompt for the description field without which the row won't be created. Add a Description.
5. From the columns picker add "Description" to the Grid.
6. Double click the description and remove it.

Expected Results :- Application doesn't allow the description to be removed
Actual Results :- Description is removed. Subsequent DWH runs fail.

Environment

Clarity PPM 16.3.3

Cause

DE176074

Resolution

Fixed in 16.4.1 and above.

Workaround:

On the PPM schema run this query to find the null record:

                  select * from DWH_FIN_PLAN_DET_DESC_V where detailed_record_description is null

This will show you the investment key and plan key so you can find the investment and plan.

Check the plan for a child with a null description field and populate it.