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: 11.5.10.2 and later   [Release: 11.5 and later ]
Information in this document applies to any platform.
pyeentry.pkb
pyeentry.pkb


This note provides a brief overview of Bug:13467399

Symptoms

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.

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