Payroll: 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 JANUARY 03, 2017

Applies to:

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

Symptoms

On : 12.1 version, Core Payroll - General

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.




BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Without this critical issue resolved, the operation cannot be continued. If the OPERATION cannot begin NOW, that will cause a delay in payments to the employees.

Changes

 
Customer loaded 1008 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 1008 employees in the Assignment Set were part of the  Massive load of assignments via API.

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