My Oracle Support Banner

"ORA -01403 :no data found "Error While Creating New Serial Number in Depot Repair Repair Order Form (Doc ID 2434922.1)

Last updated on AUGUST 13, 2018

Applies to:

Oracle Depot Repair - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Repair Order Management


While entering a new serial number in depot repair under the Details tab, instead of adding it to Installed Base, the system is throwing following error


ERROR
-----------------------
ORA -01403 :no data found

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04062.

ISSUE SCOPE
-----------------
Issue is not specific to single repair order.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Applications
2. Go to Depot Repair responsibility
3. Enter the Service Request details and enter new serial number in details tab
4.Click "Add to IB" button

Observe the above error



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!


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