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:
Oracle Inventory Management - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]Information in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |