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'
Go to the Administration > Studio > Object > Benefit Plan Details >
Remove the unnecessary attributes and re-added the needed ones.