My Oracle Support Banner

Intransit Receipt Transaction for Lot Status Controlled Item is Raising Error "ORA-01422: exact fetch returns more than requested number of rows" when 2 or More Lots are Shipped (Doc ID 2916365.1)

Last updated on JANUARY 20, 2023

Applies to:

Oracle Inventory Management - Version 12.2.11 and later
Information in this document applies to any platform.


Intransit Receipt Transaction is raising error for lot status controlled item if 2 or more lots are shipped during Intransit Shipment Transaction.




ORA-01422: exact fetch returns more than requested number of rows

FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01422




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

  1. Go to Inventory Responsibility > create Lot controlled item in Onhand Status enabled Organization;
  2. Perform Miscellaneous Receipt for 2 lots;
  3. Define Shipping network between 2 organization with Transfer Type set as 'Intransit';
  4. Perform Inter-Org Transfer for the total quantity and ship quantity from 2 lots;
  5. Perform Intransit Receipt in the receiving Organization and get the error when trying to perform receipt for both lots - system only allows receipt for one of the lots.



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.