We receive the following error when we try to use "Populate from Allocation" in a Cost Plan, in the Modern UX:
Error while Populating Cost Plan from Allocations
The following corresponding error in the app-ca.log is noticeable:
ERROR 2021-31-31 25:06:08,273 [https-jsse-nio2-8444-exec-1903] services.CostPlanDetailInsertService (clarity:admin:130__06F1-A231-4CA3-B51D-D5AF29E6374B:PPM_REST_API) Exception while inserting cost plan detail
com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.FIN_COST_PLAN_DETAILS_U1) violated
The FIN_COST_PLAN_DETAILS_U1 defines that the data in following set of columns be unique. When a duplicate is attempted to be inserted, an error is raised.
The Cost Plan was being grouped by Resource, Role, Cost Type and Charge Code. One of the resources in the Project Team did not have a Primary Role. Assigning a Primary Role to that team member resolved this issue.