Skip to main content

Error: 'ERRMESS :ORA-01422: exact fetch returns more than requested number of rows'

When running the generate salaries & allowances, the following error appears: SOURCEREF:s27500_irregular_claims select EE PRSI EMPNO :XXX ERRNO :XXX ERRMESS :ORA-01422: exact fetch returns more than requested number of rows

O
Written by Onyema Onyejekwe
Updated over a month ago

The above error message occurs when the PAY140 job is stuck due to employees in the trace file having multiple PRSI classes.

This happens if a manual payment was issued for a previous period without first canceling the original payment, and a different PRSI class is used in the manual payment compared with the original payment, resulting in more than one PRSI class being used.

To prevent the issue from occurring in the future, process a cancel payment before processing a manual payment.

To resolve this, please raise a new case online and reference this article title. When doing so, include the following details:

  • Payroll period

  • Pay group

Did this answer your question?