No Serial Numbers Are Listed Down When Doing Return or Correction FRM-40212 Invalid value for FM_SERIAL_NUMBER FRM-41830
(Doc ID 859312.1)
Last updated on JUNE 01, 2016
Applies to:Oracle Inventory Management - Version 11.5.1 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
RCVTXERE.FMB - Enter Returns
RCVTXECO.FMB - Enter Corrections
When attempting to return or correct specific serial numbers to supplier there are no serial numbers in the list of values.
The issue can be reproduced at will with the following steps:
1. Go to Purchasing Responsibility
2. Navigate through Receiving > Returns (or Receiving > Corrections)
2. Query PO transaction
3. Select line to return, enter quantity
4. Click lot/serial button
5. Select Ranges or Individual
6. No serial numbers exist in the LOV list
FRM-41830 List of Values Contains no entries
7. If indicating specific serial number:
FRM-40212: Invalid value for field FM_SERIAL_NUMBER
Example of data from Rcv11i output from <Note 402245.1> for the purchase order
shows the deliver transaction was initially performed in subinventory STORE1.
In RCV_TRANSACTIONS table the deliver transaction has
In RCV_SERIAL_TRANSACTIONS there is 1 record with
In MTL_UNIT_TRANSACTIONS table there is 1 record with
In MTL_SERIAL_NUMBERS table the record has
CURRENT_STATUS: 4 ---Out of Stores,
PREVIOUS_STATUS: 3 --In Stores
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!