Calculate Payroll - ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "FUSION.PAY_PAYROLL_RUN" (Doc ID 2257763.1)

Last updated on MAY 16, 2017

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Global Payroll

When attempting to calculate Payroll for all employees the following error is returned:


ERROR
-----------------------
"Error ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "FUSION.PAY_PAYROLL_RUN", line 2263 ORA-06512: at line 1 occurred in table reset_rel_group_status at location 625."

STEPS
---------
1. Run Payroll

 

BUSINESS IMPACT
---------------
Unable to pay the employees

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