Payroll Error's: Table Get_Upgrade_Status App-Pay-06881: Error Ora-01422: Exact Fetch Returns More Than Requested Number of Rows (Doc ID 1389836.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

Problem Statement:

When attempting to run Payroll or QuickPay, the following error occurs.

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

SQL_NO 1562
TABLE_NAME get_upgrade_status
APP-PAY-06881: Error ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PAY_CORE_UTILS", line 2037
ORA-06512: at line 1
has occurred in table get_upgrade_status at location 1562

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



Steps to Reproduce

The issue can be reproduced at will with the following steps:
1. Run a Payroll or a QuickPay

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