Error ORA-01422 When Query for Serial Number on Detail Line
(Doc ID 2423353.1)
Last updated on NOVEMBER 09, 2022
Applies to:
Oracle Shipping Execution - Version 12.2.1 and laterInformation in this document applies to any platform.
Symptoms
On the Shipping Transactions form, unable to view the serial number on an interfaced detail line successfully. When attempting to view the serial number, the following error occurs.
ERROR
-----------------------
ORA-01422: exact fetch returns more than requested number of rows
-------------------------------------------------
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01422
-----------------------
ORA-01422: exact fetch returns more than requested number of rows
-------------------------------------------------
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01422
.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Shipping->Transactions.
2. Query the sales order.
3. Click on Tools->Serial Entry.
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! |
In this Document
Symptoms |
Cause |
Solution |
References |