"FRM-40735: ON-UPDATE Trigger Raised Unhandled Exception ORA-01403" - Raised during Termination with Final Process Date

(Doc ID 2203693.1)

Last updated on JANUARY 15, 2018

Applies to:

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


When attempting to terminate an employee with Final Process Date value
the following error occurs.


FRM-40735 on-update trigger raised unhandled exception ORA-01403

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

1. Go to people -> Enter and Maintain

2. Query the Employee and go to End Employment Page

3. Fill the details and click on Terminate

The above error raises.


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