Unable to Deliver Lot Controlled Intransit Shipment Line IOT WMSINB-22192 Lot/Serial validation failed. (Doc ID 1105700.1)

Last updated on JUNE 01, 2016

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.
Form:RCVRCERC.FMB - Enter Receipts
Form:RCVTXERT.FMB - Enter Receiving Transactions
Executable:RVCTP - Receiving Transaction Processor


Symptoms

When attempting to deliver remaining quantity of 1 for specific intransit shipment line on specific lot number , the following error occurs.

. In Online mode
           rvtpcontrol failed

. In Immediate mode
          Concurrent program RVCTP returned error
          Cause: RVCTP encountered an internal error. Parameters: RVCTP,IMMEDIATE,xxxx

Records are stuck in RTI rcv_transactions_interface table and po_interface_errors show
WMSINB-22192:Lot/Serial validation failed.  Please check log for details.

 

Inventory debug log file shows

INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: Lot Control Code:2
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: Serial Number Control Code:1
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: Lot Status Enabled:Y
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: Lot Controlled :WMSINB-22076
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: LOT NUMBER: 905999: WMSINB-22087
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): Assigning values fetched from MTLT to l_mln_recWMSINB-22087
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: LOT PRIMARY QUANTITY: 1: WMSINB-22087
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: LOT EXISTS: 1 : WMSINB-22106
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): INVCONV, Removing OPM specific fork and selecting parent lot number :WMSINB-22143:
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: SOURCE DOCUMENT CODE: INVENTORY : WMSINB-22143
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): INVCONV, validating for parent lot :WMSINB-22143
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: LOT NOT ENTERED ON PARENT: WMSINB-22155
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): VALIDATE_LOT_SERIAL_INFO: LOT CONTROL FROM ORG: 2 : WMSINB-22161
INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.34 $): Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2010-05-04 04:04:47:WMSINB-22192

 

RVCTP trace shows the last instruction, that returns a record, is

SELECT NVL(SUM(RLS.PRIMARY_QUANTITY),0) FROM RCV_LOTS_SUPPLY RLS , RCV_SHIPMENT_LINES RSL WHERE RSL.SHIPMENT_LINE_ID =  RLS.SHIPMENT_LINE_ID AND RSL.SHIPMENT_HEADER_ID = :B3 AND RSL.ITEM_ID =:B2
AND RLS.SUPPLY_TYPE_CODE = 'SHIPMENT' AND RLS.LOT_NUM = LTRIM(RTRIM(:B1 )


It has been confirmed that the issue is not caused by Incorrect lot quantity entered when performing delivery per <Note 1077492.1> Interorg Transfer Shipment Errors: WMSINB-22192 RVTPT:040 Error in lot/serial

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