My Oracle Support Banner

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

Last updated on MARCH 12, 2021

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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.