Fusion Global Payroll: Adding Element to Employee Element Entries and Getting an Error-Unable to Submit

(Doc ID 1969813.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version to [Release 1.0]
Oracle Fusion Global Payroll - Version to [Release 1.0]
Information in this document applies to any platform.


When attempting to add an element entry for overtime premium to any person, the following error occurs:
The message is ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API", line 402 ORA-06512: at line 51

The issue can be reproduced at will with the following steps:
1. Navigator>Payroll>Payroll Calculations
2. Select the Manage Element Entries task
3. Search and select a person
4. Click the Create icon
5. Set the effective as-of date and select the overtime premium element
6. Enter the Hours and Multiple
7. Click Save then Submit
Error generates


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