My Oracle Support Banner

Transaction Failed On PO Deliver Via MSCA With Debug Error ORA-01403 No Data Found In Package INV_MATERIAL_STATUS_GRP (Doc ID 1575310.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.


While performing deliver transactions against a standard Purchase Order PO Receipt, if the PO lines have the same items but different Unit of Measures UOMs, the deliver transactions fail with the below error.

Online Transaction Failed

The inventory debug log file shows the following error message :

[03-JUN-13 17:33:50] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.118 $): VALIDATE_LPN_INFO - Execution Error:WMSINB-18129:1
[03-JUN-13 17:33:50] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.118 $): STACKED ERROR MESSAGES : |ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control|
[03-JUN-13 17:33:50] INV_RCV_INTEGRATION_APIS($Revision: 120.12.12010000.10 $): VALIDATE_LPN_INFO: x_return_status from private api: E

The issue can be reproduced at will with the following steps:
1. 1.Create Item HW-MUL-UOM with primary quantity in  Miles                    
2.Create PO with above item and standard routing, and three  PO lines are as following                                            
  purchased_uom      qty                                            
    3600ML               10                                                  
    30ML                   10                                                    
    3600ML               10                                                                            

3. Create PO receipt against above po with the following data in mobile                                                              

    po_line_num  received_qty   received_uom      
     1                      1                 3600ML                                  
     2                      1                    30ML                                    
     3                      1                 3600ML            
4 .Perform deliver against above Receipt with the following data    

          seq      deliver_qty    deliver_uom                
          1            1                3600ML                                  
          2            1                30ML                                    
          3           1                3600ML                                  

5.Receive error.           


Patches 15834208:R12.INV.B and 13744041:R12.PO.B were applied.


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.