In this Document

APPLIES TO:

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:

  When trying to view a list of serial numbers   

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

The issue is caused by incorrect validation in file RCVCOTRX.pld as explained in 
Bug 8839059 RETURN RECEIPT: FRM-40212 INVALID VALUE FIELD FM_SERIAL_NUMBER

There is one restriction to prevent returning serials against earlier deliver, as the serial is also delivered by another later deliver transaction.

This issue has been fixed 
. In release 12.0.x in the file RCVCOTRX.pld 120.32.12000000.52 or higher
. In release 12.1.x in the file RCVCOTRX.pld  120.53.12010000.25 or higher


The raw trace shows the last instruction that returns no record is the following 

The serial numbers that have been first delivered for PO 1586 
have later been issued by miscellaneous issues and delivered via RMA receipt: 

Material Transactions form shows the following transactions occurred for item 507019 Serial: GB89469 
after initial PO receipt 
Source Type Source Transaction type 
Inventory Miscellaneous receipt 
Inventory Miscellaneous issue 
Inventory Subinventory transfer 
Inventory Subinventory transfer 
RMA 200901... RMA Receipt 
Sales Order 200923....Sales Order issue 
Sales Order 200923.... Sales Order Pick 
Sales Order 200923.... Sales Order Pick 
Purchase Order 1586 PO Receipt 


Rcv11i output for PO 1586 shows the deliver transaction in rcv_transactions table has 
transaction_id= 1737312 

The following sql script returns a RMA record 

Select rt2.* from rcv_transactions RT2, mtl_material_transactions mmt2, mtl_unit_transactions mut2 
WHERE RT2.transaction_id >1737312 
AND RT2.transaction_type = 'DELIVER' 
AND RT2.transaction_id = mmt2.rcv_transaction_id 
AND MMT2.transaction_id = mut2.transaction_id 
AND MUT2.serial_number ='GB89469' 
AND MUT2.inventory_item_id = 689007 
AND MUT2.organization_id = 778; 

it returns a record with 
TRANSACTION_TYPE DELIVER 
INTERFACE_SOURCE_CODE RCV 
SOURCE_DOCUMENT_CODE RMA 

As a consequence the serial numbers will not appear in the LOV

SOLUTION

For Release 12.0.x
--------------------
1. Download and review the readme and pre-requisites for Patch 8839059:R12.PO.A

2. Ensure that you have taken a backup of your system before applying the recommended patch. 

3. Apply the patch in a test environment. 

4. Confirm the following file versions: 
resource/RCVCOTRX.pld 120.32.12000000.52 

You can use the commands like the following: 
strings -a $AU_TOP/resource/RCVCOTRX.pll |grep '$Header' 

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.


For Release 12.1.x
---------------------
1. Download and review the readme and pre-requisites for Patch 10302131:R12.PO.B

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
          RCVCOTRX.pld  120.53.12010000.53

   You can use the commands like the following: 
   strings -a $AU_TOP/resource/RCVCOTRX.pll |grep '$Header' 

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

REFERENCES