My Oracle Support Banner

Error "FRM-40735: KEY-DELREC Trigger Raised Unhandled Exception ORA-20002" Thrown, When Trying to Delete Absence Using Forms / PUI (Doc ID 2771535.1)

Last updated on APRIL 27, 2021

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP12 and later
Information in this document applies to any platform.

Symptoms

When trying to delete an absence record, following error appears

ERROR 1
----------

FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-20002

ERROR 2
----------

ORA-20002: 3124: Process 'HR_<PROCESS_NAME>_PRC' for item 'HRSSA/<ITEM_KEY>' is not active.
ORA-06512: at "APPS.<PACKAGE_NAME>_API", line <LINE_NO>


STEPS
--------

The issue can be reproduced at will with the following steps:

1. Login using "HRMS Manager" responsibility

2. Navigate to People -> Enter and Maintain

3. Query for the employee record

4. Navigate to Others -> Absence

5. Try deleting the absence record

6. Encounter Error 1

7. Generate FRD Trace on the error using the Doc ID 438652.1 - R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications

8. When reviewing FRD Trace, observed that Error 2 is captured as part of it

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.