Unable to Return Serialized Item, 0 choice for Serial Number LOV, FRM-40212 (Doc ID 1053770.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:RCVTXERE.FMB - Enter Returns


Symptoms

When attempting to perform a return for some serial controlled items of specific purchase order , the LOV on Serial Number does not retrieve any valid serial number
(see message choices in list = 0) 

Steps to reproduce
The issue can be reproduced at will with the following steps:
1. Onhand window shows that the item with the serial is available in stock
2. Navigate to Enter returns form RCVTXERE
3. Search for the PO
4. Record is available for return to supplier
5. Click on Lot / Serial button
6. In Serial Entry form
LOV for serial number does not return any record and error displays:

  

What has been checked
The serial number is available to transact when doing a miscellaneous issue transaction.
However, it is not available when trying to perform a return.
The subinventory is a normal quantity tracked subinventory.
There is sufficient On-hand Available Quantity for the serial number in the Subinventory/Locator where the initial deliver transaction was performed.
The serial number exists in the table mtl_serial_numbers, resides in store and is not marked.
There are no pending transactions in mtl_transactions_interface and no material transactions in mtl_material_transactions_temp for this serial number.

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