ROI RVCTP Errors Receiving Purchase Orders for Serial Controlled Items WMSINB-23482:Lot/Serial validation failed

(Doc ID 338308.1)

Last updated on AUGUST 20, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
RVCTP - Receiving Transaction Processor

Symptoms

Receipts are inserted through Receiving Open Interface for some standard purchase orders in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE table for Serial Controlled Items

For one transaction RVCTP is failing with the following errors:


After setting profile options as indicated in <Note 299497.1> the Inventory debug file shows

INV_RCV_INTEGRATION_PVT: SPLIT_LOT_SERIAL:l_total_serial_qty:10
INV_RCV_INTEGRATION_PVT: SPLIT_LOT_SERIAL:l_lot_ser_qty:0
INV_RCV_INTEGRATION_PVT: split_lot_serial:080: current record 1
INV_RCV_INTEGRATION_PVT: split_lot_serial:090: orig interface trx id 5154
INV_RCV_INTEGRATION_PVT: split_lot_serial:100: new interface trx id 5154
INV_RCV_INTEGRATION_PVT: split_lot_serial:110: transaction_quantity 10
INV_RCV_INTEGRATION_PVT: split_lot_serial: new_interface_trx_id = 5154
INV_RCV_INTEGRATION_PVT: split_lot_serial:270: Exit Stamp :2005-10-14 11:14:57
INV_RCV_INTEGRATION_PUB: inv_rcv_integration_pvt.split_lot_serial returned success
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: RTI_ID = : 5154
INV_RCV_INTEGRATION_PVT: move_lot_serial_info - Number of MTLT Inserted =: 0 with product transaction_id = 5154
INV_RCV_INTEGRATION_PVT: move_lot_serial_info - Number of MSNT Inserted =: 1 with product transaction_id =5154
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: MOVE_LOT_SERIAL_INFO done :WMSINB-21949
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: RTI query done :WMSINB-21964
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: TRANSACTION TYPE: RECEIVE: WMSINB-21964
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: MTL_SYSTEM_ITEMS query done :WMSINB-22021
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Lot Control Code:1
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Serial Number Control Code:5
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Lot Status Enabled:N
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: SERIAL CONTROLLED: WMSINB-22076
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: SERIAL CONTROL CODE: 5 : WMSINB-22076
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: SOURCE DOCUMENT CODE: PO : WMSINB-22076
INV_TRX_MGR: *** Initializing log ***
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: 10 : WMSINB-23198
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: SERIAL EXISTS: 1 : WMSINB-23233
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: SERIAL NUMBER: 10905 : WMSINB-23233
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: CURR STATUS: 3 : WMSINB-23233
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: CURR ORG ID: 572 : WMSINB-23233
...
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: ASN LINE FLAG: N : WMSINB-23276
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: SERIAL NOT ENTERED ON PARENT: WMSINB-23287
INV_RCV_INTEGRATION_PVT: Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2005-10-14 11:14:58:WMSINB-23482
INV_RCV_INTEGRATION_PVT: STACKED ERROR MESSAGES : Fail to validate serials

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