R12 Unable to Complete Receiving Transactions for ISO / IOT Intransit Shipment WMSINB-22192 WMSINB-23184:Lot/Serial validation failed. (Doc ID 973613.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 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

***Checked for relevance on 18-Mar-2014***

Symptoms

When attempting to deliver a specific Inter Organization transfer Shipment for lot controlled item the following error occurs:
  
Error

RVCTP completes in error,
Records are stuck in rcv_transactions_interface and po_interface_errors show some records:

INTERFACE_TYPE    ERROR_MESSAGE    

RCV-856    Lot/Serial validation failed. Please check log for details.   
RCV-856    WMSINB-23184:Lot/Serial validation failed. Please check log for details. 
Or
RCV-856    WMSINB-22192:Lot/Serial validation failed. Please check log for details. 



Inventory debug log file shows
[24-NOV-09 18:44:10] INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.25
$): VALIDATE_LOT_SERIAL_INFO: Lot Control Code:2
...
Serial Number Control Code:1
Lot Status Enabled:Y
Lot Controlled :WMSINB-22076
LOT NUMBER: 6963: WMSINB-22087
Assigning values fetched from MTLT to l_mln_recWMSINB-22087
LOT PRIMARY QUANTITY: 1: WMSINB-22087
1 : WMSINB-22106
...
SOURCE DOCUMENT CODE: INVENTORY : WMSINB-22143
INVCONV, validating for parent lot :WMSINB-22143
LOT NOT ENTERED ON PARENT: WMSINB-22155
LOT CONTROL FROM ORG: 2 : WMSINB-22161
[24-NOV-09 18:44:10] INV_RCV_INTEGRATION_PVT($Revision: 120.77.12000000.25
$): Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2009-11-24
06:24:10:WMSINB-22192

RVCTP Trace shows
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 ))


The receive transactions have been entered via the form.

Steps
The issue can be reproduced at will with the following steps:
1. Navigate to Receiving > Receiving Transactions (Form RCVTXERT)
2. Try to deliver the lines of Shipment Number for lot controlled item

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