NL PERWSHRG; FRM-40375: No Data Found; POST-DELETE Trigger Raised Unhandled Exception ORA-01403 when deleting next assignment

(Doc ID 2085053.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle HRMS (Netherlands) - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Person / Assignment Issues

When attempting to delete employee assignment
the following error occurs.


ORA-01403: No data found
FRM-40375: POST-DELETE trigger raised underhanded exception ORA-01403

The issue happens to all employees after applying patch R12.HR_PF.B.8(20000288)

The issue can be reproduced at will with the following steps:
1. Responsibility : NL HRMS Manager
2. People> Enter and maintain>
3. Click on assignment button
4. Delete button> Next
5. Save changes
6. Above error occurs


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