Adding Element Entry, Error's: ORA-01422: Exact Fetch Returns More Than Requested Number of Rows

(Doc ID 1383804.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Payroll - Version: and later   [Release: 11.5 and later ]
Information in this document applies to any platform.

This note provides a brief overview of Bug:13467399


Problem Statement:

When attempting to add an element to a assignment which has employee with multiple periods of service ( i.e. terminated / rehired), the following error occurs.

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.HR_ENTRY", line 29
ORA-06512: at "APPS.HR_ENTRY", line 3264
ORA-06512: at "APPS.HR_ENTRY_API", line 3747
ORA-06512: at "APPS.HR_ENTRY_API", line 5082

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01422.


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