Error On Creation Of New Employee - ORA-01403: no data found || FRM-40735: ON-INSERT trigger raised unhandled exception ORA-12899 (Doc ID 2879145.1)

Last updated on JUNE 27, 2022

Applies to:

Symptoms

While creating new employee record getting below error:

ERROR
-----------------------

ORA-01403: no data found

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate to HRMS Manager > People Enter and Maintain

2. Create new employee.

3. Getting error on save.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.