23259092:Error With Batch Loader - ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows
Last updated on AUGUST 25, 2017
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Global Payroll - Version 220.127.116.11.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
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