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 MAY 18, 2016

Applies to:

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

Symptoms

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.

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

STEPS
-----------------------
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.           

Changes

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

Cause

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 hundreds of Community platforms