My Oracle Support Banner

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 FEBRUARY 03, 2019

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

To view full details, 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 a vibrant support community of peers and Oracle experts.