Cannot End Date Absences, Error: FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01001
Last updated on SEPTEMBER 26, 2016
Applies to:Oracle HRMS (Norway) - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Norway Payroll
When attempting to change end date of the absence in the "Absence Detail(PERWSEAD.fmb)" form the following error occurs.
FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01001
APP-PAY-06153: System Error: Procedure hr_entry_api.delete_element_entry at Step 1
Cause: The procedure hr_entry_api.delete_element_entry has created an error at Step 1
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Create the absence from 1-JAN-2015 to 3-JAN-2015 in the "Absence Detail" form.
- Responsibility: Norway HRMS Manager
- (N) People > Enter and Maintain > (B) Others > Absence -try to end-date
- See error
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