ORA-01403: No Data Package INV_MATERIAL_STATUS_GRP Procedure Get_lot_serial_status_control 'Error loading LPN' In wsh_delivery_details Direct Ship LPN
(Doc ID 2754489.1)
Last updated on JULY 01, 2023
Applies to:
Oracle Warehouse Management - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5 version, Pick Drop
When attempting to direct ship LPN, the following error occurs:
Error
ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
Database error occurred.
Error loading LPN
Error: Record with this combination already exists.
ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Pro..
Steps
The issue can be reproduced at will with the following steps:
Receiving above error over and again for direct ship LPN transactions with multiple records in wsh_delivery_details see on inspection.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |