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