Fusion Global Payroll: Error with Batch Loader - ORA-01422: Exact Fetch Returns More than Requested Number of Rows
(Doc ID 2162998.1)
Last updated on OCTOBER 06, 2020
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 22.214.171.124.0 and later
Oracle Fusion Global Payroll - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
When attempting to create element entry for Deferred Cash element 2017,
the following error occurs.
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "FUSION.PAY_BATCH_LDR_PKG", line 1846
ORA-06512: at line 1
The issue can be reproduced at will with the following steps:
1. Login to application and navigator > My Workforce > Person Management
Search Employee 999999 as of effective date 3/15/17
2. Go to element entry page
3. Click on Deferred Cash 2017 element entry and in correction mode change the input values and Save it.
Following error message in appear:
The message is ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API", line 1153 ORA-06512: at line 32
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