When Hiring Applicant, Frm-40735: On-Update Trigger Raised Unhandled Exception Ora-01422. (Doc ID 335853.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.0 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 31-Jul-2014***


Symptoms

Hiring applicant errors:

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.HRENTMNT", line 5677
ORA-06512: at "APPS.HRHIRAPL", line 1074
ORA-06512: at "APPS.HRHIRAPL", line 2190
ORA-06512: at "APPS.PER_PEOPLE12_PKG", line 1176
--------------------------------------------------------------
FRM-40735: ON-UPDATE 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