UK Pay: When Updating Extra Details Of Service Error FRM-40735 ON-UPDATE Trigger Raised ORA-04098
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:
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