My Oracle Support Banner

Unable to Return Serialized Item, 0 choice for Serial Number LOV, Error FRM-40212 (Doc ID 1053770.1)

Last updated on OCTOBER 28, 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:RCVTXERE.FMB - Enter Returns


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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.