Unable To Deliver Internal Sales Order Receipt WMSINB-22145:Lot/Serial Validation (Doc ID 1607558.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information 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

 

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