Unable To Deliver Internal Sales Order Receipt WMSINB-22145:Lot/Serial Validation
(Doc ID 1607558.1)
Last updated on AUGUST 18, 2023
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to deliver some internal sales order RVCTP completes in error and the transaction is stuck with the following error:
When debugging RVCTP Inventory debug log file shows the following
[20-DEC-13 01:21:52] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): VALIDATE_LOT_SERIAL_INFO: LOT EXISTS: 1 : WMSINB-22106
[20-DEC-13 01:21:52] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): INVCONV, Removing OPM specific fork and selecting parent lot number :WMSINB-22143: LOT OPEN DATA
[20-DEC-13 01:21:52] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2013-12-20 01:20:52:WMSINB-22145
[20-DEC-13 01:21:52] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): STACKED ERROR MESSAGES : Parent Lot Number supplied does not exist in the Lot Master or Temp Lot Master table.
[20-DEC-13 01:21:52] INV_RCV_INTEGRATION_APIS($Revision: 120.12.12010000.5 $): validate_lot_serial_info: private API new debug
[20-DEC-13 01:21:52] po.src.rvtp.rvtpt.RVTPT.C.3924: RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint
Receiving data collection output for the internal requisition shows
1- In RCV_TRANSACTIONS_INTERFACE
| INTERFACE_TRANSACTION_ID | 224699 |
| TRANSACTION_TYPE | DELIVER |
| TRANSACTION_STATUS_CODE | ERROR |
| QUANTITY | 11 |
| SHIPMENT_HEADER_ID | 17895 |
| SHIPMENT_LINE_ID | 14516 |
| RECEIPT_SOURCE_CODE | INTERNAL ORDER |
| SOURCE_DOCUMENT_CODE | REQ |
| DESTINATION_TYPE_CODE | INVENTORY |
| USE_MTL_LOT | 2 |
| USE_MTL_SERIAL | 1 |
2- In PO_INTERFACE_ERRORS
| ERROR_MESSAGE | Parent Lot Number supplied does not exist in the Lot Master or Temp Lot Master table. WMSINB-22145:Lot/Serial validation failed. Please check log for details. |
| TABLE_NAME | RCV_TRANSACTIONS_INTERFACE |
| INTERFACE_LINE_ID | 224699 |
3- In RCV_LOTS_INTERFACE
| INTERFACE_TRANSACTION_ID | 224699 |
| LOT_NUM | CH LOT OPEN DATA |
| QUANTITY | 11 |
| ITEM_ID | 53784 |
| SHIPMENT_LINE_ID | 14516 |
| PARENT_LOT_NUMBER | LOT OPEN DATA |
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 |