Cannot End Date Absences, Error: FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01001

(Doc ID 2180076.1)

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.

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



Changes

 

Cause

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