PERWSDED ORA-01422 Exact Fetch Returns More Than Requested Number of Rows (Doc ID 862486.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to Delete a specific employee, the following error occurs on Form PERWSDED

ERROR

"ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.CAIBR_HR_PERIODS_SERVICE_T2", line 65
ORA-04088: error during execution of trigger
'APPS.CAIBR_HR_PERIODS_SERVICE_T2'
ORA-06512: at "APPS.HR_PERSON_API", line 1935"


Steps to Reproduce
The issue can be reproduced at will with the following steps:
      1. UK HRMS Manager

     2. People > Delete Person Records > Query employee

     3. Click on Delete Person

     4. Error occurs

Changes

 

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