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 11.1.8.0.0 to 11.1.10.0.0 [Release 1.0]
Oracle Fusion Global Payroll - Version 11.1.8.0.0 to 11.1.10.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

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



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