Same Serial Number With Serial Generation = At Sales Order Issue Can Be Received Multiple Times On Same Item for RMA (Doc ID 1640374.1)

Last updated on JUNE 19, 2024

Applies to:

Symptoms

While performing receiving transactions for a Return Material Authorization (RMA), find Serial Entry form allows to receive same serial number twice wrongly for items with serial generation at sales order issue.
 
Steps
The issue can be reproduced at will with the following steps:

1.  Item F-Serial-Sales-Order Issue has Serial Generation = At Sales Order Issue

2. In the receiving organization M1 Check-box "Validate Serial Numbers on RMA Receipts" on the Receiving Options is not checked.

3. In Order Management  responsibility
Create and book RMA with 2 lines for same Item F-Serial-Sales-Order Issue  
 
4. In Purchasing responsibility
(N) Receiving / Receipts RCVRCERC form
Find Expected Receipts (M1) form
Search for RMA Num
 
5. See 2 lines for Item F-Serial-Sales-Order Issue
 
6. Select line 1 / Enter Quantity 1 / Destination type to Inventory / Enter Subinventory

7. Click on Lot - Serial button. In Serial Entry (M1) INVTTELT form
Serial Number Entry Mode  -- Select Individual
Start Serial Number = Enter SerialF1
Click Done
 
8. Save 1st line / Close form
 
9. Navigate back to Find Expected Receipts (M1) form and search for same RMA Num.
 
10. Select new line  and enter necessary information for quantity 2

11. In Serial Entry (M1) form
Serial Number Entry Mode = Ranges
Start Serial Number = SerialF1
End Serial Number = SerialF12
 
-- Record can be saved on same serial number SerialF1
 
12. In Inventory  responsibility
Transactions / Material Transactions
Find Material Transactions (M1) form
See 2 records for Item F-Serial-Sales-Order Issue
Click on  Lot / Serial button
See for Item F-Serial-Sales-Order Issue same serial number SerialF1 has been received twice. !
 
13. Receiving Data collection script for the RMA shows the following data:

> OE_ORDER_LINES_ALL - See 2 lines for the same inventory item and both have category code Return (line_category_code of RETURN).

> MTL_UNIT_TRANSACTIONS - for Serial_Number SerialF1 there are 2 records: There are more than one record with same serial_number with distinct RCV PRODUCT_TRANSACTION_ID

> RCV_SERIAL_TRANSACTIONS - for Serial_Number SerialF1 there are 4 records with same serial_num / on different SHIPMENT_LINE_ID

Changes

Cause

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