Delete Multiple Errored Records from the Pending Jobs and Schedules Form Results in Error: FRM-40735:ON-DELETE Trigger Raised Unhandled Except. ORA-01403 (Doc ID 1983329.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Work in Process > Pending Jobs and Scedules

ACTUAL BEHAVIOR
--------------------------
When trying to delete multiple errored records from the Pending Jobs and Schedules form, the following error is seen :

ERROR:
----------
ORA-01403: no data found
--------------------------------------------------------------
FRM-40735: ON-DELETE trigger raised unhandled exception ORA-01403.

EXPECTED BEHAVIOR
-----------------------------
Expect that the mass delete option should work correctly

WHAT IS WORKING
---------------------------
When trying to delete the records one by one, no error is given.


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

1. Navigation : Work in Process>Pending Jobs and Schedules Form

2. Select All records via (M) Edit -> Select All.

3. Then press Delete button (red cross).

4. Get the above error.

5. If the records are deleted one by one, there is no error.



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