Create Payment Paysheets Error ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2010888.1)

Last updated on MAY 15, 2015

Applies to:

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

Symptoms

When attempting to Generate of payment sheets, the following error occurs.

ERROR

From the log file ( 133835.log )  shows:

The validations for creation of paysheet is successful for participant :10105 for the payrun :300000004375622
Calling cn_tp_participant_pay_pkg.insert_record
****Entered the procedure cn_tp_paysheets_pvt.calculate_totals****
****Valid payment plan exists for the participants for this period****
Entering the procedure cn_tp_paysheets_pvt.proc_pmt_trans_by_pe
Leaving the procedure cn_tp_paysheets_pvt.proc_pmt_trans_by_pe
calculate total1 pay date =30-09-2014
Entering the procedure cn_tp_paysheets_pvt.proc_pmt_trans_by_pe
Leaving the procedure cn_tp_paysheets_pvt.proc_pmt_trans_by_pe
Leaving the procedure cn_tp_paysheets_pvt.calculate_totals
ORA-01422: exact fetch returns more than requested number of rows
Error when creating Worksheet for : 10105

STEPS
1. Submit request to create paysheets : Navigator > Payment > Create Payment Batch
2. Check status of job : Navigator > Payment > View Process

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