My Oracle Support Banner

Error "Lot number is already being used" in Inventory Lot Merge WMS Mobile Page (Doc ID 1502162.1)

Last updated on AUGUST 07, 2021

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On release 12.1.3:

When attempting to merge different parts of same item lot in Inventory Lot Merge mobile page, the following error occurs if the user enter the same lot number consequently, eg if the user scans part of lot 1 and then another part of lot 1.
The problem does not occur if the user scans part of lot 1, part of lot 2, part of lot 1 again, part of lot 2 again: the transaction is successful. However in this case the field "Avail Qty" does not consider the lot quantities entered during the transaction.

To reformulate, the user will do the following in Inventory Lot Merge page:
1) Scan lot 1 - piece 1
2) Scan lot 1 - piece 2 ** here the error occurs, unable to proceed further
3) Scan lot 2 - piece 1
4) Scan lot 2 - piece 2
What is working:
1) Scan lot 1 - piece 1
2) Scan lot 2 - piece 1
3) Scan lot 1 - piece 2 ** here the Avail Qty is incorrect
4) Scan lot 2 - piece 2 ** again the Avail Qty is incorrect
5) Able to complete the transaction

-- Error
"Lot number is already being used. Press any key to continue."

-- Steps
The issue can be replicated at will like below:


INITIALIZATION
--------------
1. Create a new master item
Primary UOM: KG
Secondary UOM: EA
Deviation Factor+: 10000
Deviation Factor-: 100
2. Assign the item to the WMS organization
3. Define a UOM conversion for this item
1 EA of class Count = 95.6 KG of class Mass
4. Perform an Alias Account receipt
Receive 400 KG / 4 EA like in two new lots:
200 KG / 2 EA in lot 1
200 KG / 2 EA in lot 2

EXECUTION
---------
In the mobile:

Test Case 1:
1. Go to Inventory Lot Merge page
2. Enter lot number 1 as starting lot number
Skip LPN field
Confirm the subinventory and locator
Enter Lot Qty as 100 KG
Confirm secondary lot quantity as 1 EA
Select Save/Next
3. Again enter lot number 1
See the reported error
4. Exit

Test Case 2:
1. Go to Inventory Lot Merge page
2. Enter lot number 1 as starting lot number
Skip LPN field
Confirm the subinventory and locator
Enter Lot Qty as 100 KG
Confirm secondary lot quantity as 1 EA
Select Save/Next
3. Enter lot number 2
Go ahead as above, enter 100 KG / 1 EA as lot quantity
Select Save/Next
4. Enter lot number 1
Go ahead as above, enter 100 KG / 1 EA as lot quantity
NOTE: Avail Qty is still showing 200 KG where you would expect 100 (200 - 100 selected at step 2).
Select Save/Next
5. Enter lot number 2
Go ahead as above, enter 100 KG / 1 EA as lot quantity
Select Save/Result
6. In Save Result page:
Generate the result lot number
Set a new subinventory
Select Done
Getting message "Txn Success."

-- Business impact
Due to this issue the user cannot operate properly.

 

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


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