When Attempting to Change Employee's Assignment Status errors, FRM-40735, ORA-1422: exact fetch returns more than requested number of rows and ORA-06512: at "APPS.HRENTMNT" (Doc ID 332003.1)

Last updated on MARCH 28, 2017

Applies to:

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

***Checked for relevance on 09-Mar-2013***


Symptoms

We want to change an employee's assignment status to Leave without Pay, but the application generates an error.

Navigation:

Search for employee.
Date-track to Aug 19 (when employee went on leave).
Click on Assignment.
Change assignment status to "Leave without Pay"
Click on "Update"
Click on Save on toolbar; error generated:

FRM-40735: POST-UPDATE trigger raised unhandled exception ORA-01422
---------------------------------------------------

FRM-40735: POST-UPDATE trigger raised unhandled exception ORA-01422
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.HRENTMNT", line 5744
ORA-06512: at "APPS.PER_ASSIGNMENTS_F1_PKG", line 5744
ORA-06512: at "APPS.PER_ASSIGNMENTS_F1_PKG", line 902

  

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