Repair Order Error: FRM-40735 ON-INSERT trigger raised unhandled exception ORA-01086 (Doc ID 1278461.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Depot Repair - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 26-Jun-2015***

Symptoms

In the Repair Order screen: when attempting to create a repair order different errors can occur:

ORA-01403: No data found.
FRM-40735 ON-INSERT trigger raised unhandled exception ORA-01086


or

FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-01403



The issue can be reproduced at will with the following steps:
1. Connect to the application using a suitable responsibility (e.g. Depot Repair Super User).
2. Open Repair Orders form, and attempt to create or query a repair order.

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