Generic Cost Plan Error on Populate from Assignments and Populate From Team Allocation

Products

• Clarity PPM SaaS

Issue/Introduction

Modern error when populating from cost plan:
Error occurred contact system administrator

STEPS TO REPRODUCE:
1. Go to a project cost plan.
2. Populate from either 'Populate from Assignments' or 'Populate From Team Allocation'

Expected: Cost plan should populate without an error. If it does, there should be a reason why it failed.
Actual: Cost plan creating gives error. It gets created but does not have any data

Workaround: Populate the role for all the team/staff listed.

Excerpt from APP log:

ERROR 2024-03-13 12:33:40,723 [http-nio-80-exec-16] ppm.rest (clarity:admin:session:PPM_REST_API) (792da59f-c5ac-4bda-8135-5ac6a86a4fd3) CostPlanPopulationFunctionResource :: Problem occurred while populating Cost Plan : 7178006
com.niku.union.service.ServiceException:  Exception in ResourcePlanProcessingService: com.niku.union.persistence.PersistenceException: 
SQL error code: 1427
Error message: ORA-01427: single-row subquery returns more than one row

Executed:
UPDATE (SELECT
         ddd.budget_detail_id,
         ddd.plan_id,
         ddd.charge_code_id,
         ddd.cost_type_id,
         ddd.department_id, ......

Resolution

The cost plan population/update failure root cause, although unknown, is due to the
role_id = 0 on the FIN_PLANS table.

It cannot be null nor 0.
It has to be set to a valid new/existing role_id.