My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.

ORA-01422: exact fetch returns more than requested number of rows
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01422


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.


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

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