My Oracle Support Banner

When Trying To Create a New Employee in HRMS Manager Responsibility – People Form PERWSHRG an Error Is Raised "ORA-01403: no data found" and "FRM-40735: ON-INSERT trigger unhandled exception ORA-01502" (Doc ID 3067965.1)

Last updated on JANUARY 22, 2025

Applies to:

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

Symptoms

When attempting to create a new employee under HRMS Manager responsibility -> People form - PERWSHRG
the following error occurs:


ORA-01403: no data found
FRM-40735: ON-INSERT trigger unhandled exception ORA-01502


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

1.(N) HRMS Manager -> People form.
2. Create a new employee -> Provide all the required details.
3. Save -> Error is raised.



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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