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.


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

ORA -01403 :no data found

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

Issue is not specific to single repair order.

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


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.