Repair Order Error: 'FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-04062' When Changing The Start Status (Doc ID 1471382.1)

Last updated on JULY 27, 2020

Applies to:

Symptoms

On : 12.1.3 version, Depot Setup

When attempting to change the Start Status for repair type in Depot Repair, the following error occurs:

ERROR
-----------------------
 FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-04062


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in with Depot Repair responsibility.
2. Open Repair Types form.
3. Select a repair type from the list and click Repair Order Status Transitions button.
4. In Repair Order Status Transition form, try to change the Start Status from New to Open.
The error is generated.

Changes

Cause

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