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 JUNE 17, 2022
Applies to:
Oracle Fusion Global Payroll Cloud Service - Version 11.1.10.0.0 and laterOracle Fusion Global Payroll - Version 11.1.10.0.0 and later
Information in this document applies to any platform.
Symptoms
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
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 |
Cause |
Solution |
References |