My Oracle Support Banner

Error on trying to Save Position Hierarchy - "ORA-01403: no data found" and "FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01400" (Doc ID 2612695.1)

Last updated on NOVEMBER 25, 2019

Applies to:

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


When trying to create a New Position Hierarchy and save, following errors appears

Error Message 1:

"ORA-01403: no data found"

Error Message 2:

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


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

1. Login using "SuperUser Purchasing" responsibility.

2. Navigate to Setup --> Personnel --> Position Hierarchy.

3. Key in a new Position Hierarchy name and when trying to save, got the above error message 1.

4. On click of "Ok" in error message 1 box, and try to enter some other details like "Date From" or "Number".

5. At this point application throws an error saying "APP-PER-50024: You must save your work before you can continue.".

6. After closing this error message, when they try to save again, then only you got the above error message 2 displayed on the status bar.


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

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