Error Occurs When Importing Estimates to Actuals 'ORA-01403: no data found' And One Line Is imported At A Time (Doc ID 2143644.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.

Symptoms

On : 12.1.3

After applying the fix in Bug 20304648 - SHIP TO ADDRESS ON SALES ORDER LINE IS NOT DEFAULTING CORRECTLY FROM REPAIR ORDER
Users are receiving an error when attempting to import Estimate lines to Actuals

When attempting to import the estimate line into repair actuals in repair order form, the following error occurs
ORA-01403: no data found
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01086.


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

1. Create a service request, select a ship to address that is from a related customer.
2. Create the repair order
3. Add repair estimate lines (more than one)
4. Add the estimates to actuals..

The following error is seen on the form
ORA-01403: no data found
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01086.

5. Only one line is imported to actuals.
6. If add estimate lines again, it will import a second line.
7. Add estimates again the third estimate will import to actuals.



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