My Oracle Support Banner

Payroll Process Error: SQL_NO 1578 ERROR on TABLE_NAME pyoiact: APP-PAY-06881: Error ORA-01422: exact fetch returns more than requested number of rows. ORA-06512: at "APPS.HR_DYNSQL", line 2135 (Doc ID 2003981.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Payroll - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Receive the following error when running Payroll Process

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.HR_DYNSQL", line 2135

SQL_NO 1578
TABLE_NAME pyoiact
APP-PAY-06881: Error ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.HR_DYNSQL", line 2135
 has occurred in table pyoiact at location 1578

Cause: an oracle error has occurred. The failure was reported on table pyoiact at location 1578 with the error text ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.HR_DYNSQL", line 2135
.

Action: Please contact your support representative.



Changes

 
Customer loaded employees into the system via API
The Payroll process is erroring for these employees
They believe that the employee records are duplicated.
They attempted to delete or update , but the application does not allow it.

The payroll run that is erroring is run via Assignment Set
The employees in the Assignment Set were part of the  Massive load of assignments via API.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.