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:

Symptoms

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

ERROR

-----------------------

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

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

STEPS

-----------------------

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.

Changes

Cause

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