Skip to main content

ERROR : 'ORA-01427: single-row subquery returns more than one row'

When running the PAY355 job, the following error appears.

O
Written by Onyema Onyejekwe
Updated over 3 months ago

If you encounter the following error while running the complete update job, it indicates that the issue previously occurred when the pay290 job was executed, followed by a change in the calendar.

This situation causes the 'TEMP_NON_TSHEET' table to populate twice with the same information (referenced in the table), but for two different payroll periods.

To resolve this, retrieve the relevant text files, such as pay355.log. To do this, check how to retrieve a log file then raise a new case online, referencing this article's title and include the following:

  • The affected payroll period.

  • Changes made to the calendar.

Did this answer your question?