Serial Number Is Not Showing In Intransit IOT Shipment In Serial Entry Form RCVTXERT FRM-40212 (Doc ID 1928587.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Find when trying to perform delivery for one intransit inter-org IOT shipment, Serial number is missing in List of Values LOV.

If manually inserting a serial number in the form, the following error message occurs:

Steps
The issue can be reproduced at will with the following steps:
1. Create Inter-Org Transfer.
2. Receive Inter organization transfer.
3. Navigate to Receiving / Receiving Transactions Form RCVTXERT.
4. Shipment Line is populated with Expected quantities, however under Lot - Serial Button, LOV has no serials to deliver.
Serial entry form shows for item Start Serial Number LOV is empty.

Output of Receiving Data Collection Script for the InterOrg Shipment IOT shows:

RCV_SHIPMENT_HEADERS
Shipment_Header_Id  1471173
Receipt_Source_Code  INVENTORY
Organization_Id          207
Shipment_Num           IOT1
Receipt_Num              1869
Ship_To_Org_Id          218

RCV_SHIPMENT_LINES
Shipment_Line_Id      1440413
Shipment_Header_Id  1471173
Quantity_Received      2
Item_Description        SIM
Item_Id                    1022
Shipment_Line_Status_Code FULLY RECEIVED
Source_Document_Code INVENTORY
From_Organization_Id  207
To_Organization_Id     218
Mmt_Transaction_Id    10725213

RCV_SERIAL_SUPPLY
Supply_Type_Code Serial_Num Shipment_Line_Id
SHIPMENT              6167         1440413
SHIPMENT              6168         1440413
there are correct records in RSL table

MTL_SERIAL_NUMBERS
Records have
INVENTORY_ITEM_ID    1022
SERIAL_NUMBER          6167   6168
CURRENT_STATUS       4
GROUP_MARK_ID        Null
LINE_MARK_ID            Null
LOT_LINE_MARK_ID     Null
OWNING_ORGANIZATION_ID 218

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