My Oracle Support Banner

Cannot End Date Absences, Error: FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01001 (Doc ID 2180076.1)

Last updated on JULY 19, 2020

Applies to:

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

Symptoms

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:

  1. Create the absence from 1-JAN-2015 to 3-JAN-2015 in the "Absence Detail" form.
  2. Responsibility: Norway HRMS Manager
  3. (N) People > Enter and Maintain > (B) Others > Absence -try to end-date
  4. See error



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.