My Oracle Support Banner

Error ORA-01422 When Query for Serial Number on Detail Line (Doc ID 2423353.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Shipping Execution - Version 12.2.1 and later
Information 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.

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.

Changes

 

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.