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 01, 2016

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 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:

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

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

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

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

. 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
 
. 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. !
 
. Receiving Data collection script for the RMA shows 
 
OE_ORDER_LINES_ALL
2 lines with  Inventory_Item_Id =199745 and Line_Category_Code =RETURN
 
MTL_SYSTEM_ITEMS
Inventory_Item_Id 199745
Organization_Id 207
Segment1 F-Serial-Sales-Order Issue
Lot_Control_Code 1
Serial_Number_Control_Code 6

RCV_PARAMETERS
Organization_Id    207
Enforce_Rma_Serial_Num    N

RCV_SHIPMENT_HEADERS
2 receipts with  Receipt_Source_Code = CUSTOMER and Ship_To_Org_Id = 207 
 
RCV_SHIPMENT_LINES
2 FULLY RECEIVED Shipment line for Item_Id 199745 
 
RCV_TRANSACTIONS
Transaction_Id Transaction_Type Transaction_Date Quantity Unit_Of_Measure Shipment_Header_Id Shipment_Line_Id Source_Document_Code Parent_Transaction_Id Organization_Id Subinventory 
2765112 RECEIVE  1 Each 2601255 2690798 RMA -1 207 
2765113 DELIVER  1 Each 2601255 2690798 RMA 2765112 207 Stores 
2765114 RECEIVE  2 Each 2601256 2690799 RMA -1 207
2765115 DELIVER  2 Each 2601256 2690799 RMA 2765114 207 Stores 


MTL_MATERIAL_TRANSACTIONS
Transaction_Id Inventory_Item_Id Organization_Id Subinventory_Code Transaction_Type_Id Transaction_Quantity Transaction_Uom Trx_Source_Line_Id Rcv_Transaction_Id Source_Code
22241749 199745 207 Stores 15 1 Ea  2765113 RCV
22241753 199745 207 Stores 15 2 Ea  2765115 RCV
 
MTL_SERIAL_NUMBERS

2 records including
Inventory_Item_Id 199745
Serial_Number SerialF1
Current_Status 1
Last_Txn_Source_Type_Id 12
Last_Transaction_Id 22241753 
Current_Subinventory_Code Stores
Current_Organization_Id 207
Previous_Status 7
 
MTL_UNIT_TRANSACTIONS
 --for Serial_Number SerialF1 there are 2 records
Transaction_Id 22241749
Serial_Number SerialF1
Inventory_Item_Id 199745
Organization_Id 207
Subinventory_Code Stores
Product_Code RCV
Product_Transaction_Id 2765113
 
and
Transaction_Id 22241753
Serial_Number SerialF1
Inventory_Item_Id 199745
Organization_Id 207
Subinventory_Code Stores
Product_Code RCV
Product_Transaction_Id 2765115
 
--> there are more than one record with same serial_number with distinct RCV PRODUCT_TRANSACTION_ID

RCV_SERIAL_TRANSACTIONS
Serial_Transaction_Type Serial_Num Usage_Status_Code Shipment_Line_Id Transaction_Id Source_Transaction_Id
TRANSACTION SerialF1 CURRENT 2690798 2765112 2765112
TRANSACTION SerialF1 CURRENT 2690798 2765113 2765113
TRANSACTION SerialF1 CURRENT 2690799 2765114 2765114
TRANSACTION SerialF1 CURRENT 2690799 2765115 2765115

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

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