ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable To Add or Delete Benefit Plan Detail Records

book

Article ID: 237673

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The following error appears in the APP log:

WARN  2022-03-15 08:09:31,456 [https-jsse-nio2-8143-exec-7] niku.xql2 (clarity:user:session:revmgr.deleteBenefitPlans) Failed to delete records from query referenced in select deleteODF :Error deleting benefitplandetail instance with PK: 6505000

Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "CLARITY.ODF_AUD_STATIC_LOV_FCT", line 22
ORA-06512: at line 1
ORA-06512: at "CLARITY.T_F_REVENUE_REC_OF_REVENUE_REC", line 309
ORA-04088: error during execution of trigger 'CLARITY.T_F_REVENUE_REC_OF_REVENUE_REC'

 

Environment

All

 

Resolution

Go to the Administration > Studio > Object > Benefit Plan Details >
Remove the unnecessary attributes and re-added the needed ones.
Click Save.