Calculation Error ORA-01427: single-row subquery returns more than one row (Doc ID 2103540.1)

Last updated on FEBRUARY 04, 2016

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run calculation, the child Eligibility job error occurs.

ERROR
CN_TP_TXNS_UTIL.revert_measures.others
SQLCODE : -1427
SQLERRM : ORA-01427: single-row subquery returns more than one row
cn_tp_eligibility_pvt.revert_total_mode.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
End of cn_tp_eligibility_pvt.revert_total_mode
cn_tp_eligibility_pvt.eligibility.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
End of eligibility phase for logical batch id 214014 and physical batch id : 1


STEPS
Navigator > Credits and Earnings > Manage Calculation processes
Submit calculation for participant for 01-NOV-15 to 30-NOV-15 in TOTAL mode.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms