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

Symptoms

When attempting to return or correct specific serial numbers to supplier there are no serial numbers in the list of values.


Steps
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:
Error message:
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
TRANSACTION_ID:  5115220
TRANSACTION_TYPE:  DELIVER
QUANTITY:  1
SUBINVENTORY:  STORE1
LOCATOR_ID:  147292

In RCV_SERIAL_TRANSACTIONS there is 1 record with
SERIAL_TRANSACTION_TYPE TRANSACTION
SERIAL_NUM  4174030-1
TRANSACTION_ID  5115220
SOURCE_TRANSACTION_ID  5115220

In MTL_UNIT_TRANSACTIONS table there is 1 record  with
SERIAL_NUMBER:  4174030-1
INVENTORY_ITEM_ID:  1389840
SUBINVENTORY_CODE:  STORE1
LOCATOR_ID:  147292
PRODUCT_TRANSACTION_ID:  5115220

In MTL_SERIAL_NUMBERS table the record has
SERIAL_NUMBER:  4174030-1
CURRENT_SUBINVENTORY_CODE:  STAGING
CURRENT_LOCATOR_ID:  147058
CURRENT_STATUS:  4 ---Out of Stores,
PREVIOUS_STATUS:  3 --In Stores

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