UK Pay: When Updating Extra Details Of Service Error FRM-40735 ON-UPDATE Trigger Raised ORA-04098

(Doc ID 2259789.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.


When attempting to update/correct an existing assignment's Extra Details of Service, on saving the changes the following error message is displayed:

ORA-01403: no data found
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-04098.

The issue can be reproduced at will with the following steps:
1. UK HRMS Manager
2. People > Enter and Maintain
3. Query in employee > Assignment > Others > select ‘Extra Details of Service’
4. Details of Service tab > Contract Type:  Update Contract Type
5. Save as update and the 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