My Oracle Support Banner

Wrong Quantity On Transact Move Order (Doc ID 1587046.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Inventory Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Unexpected User Exit Error(1), Coming From QT_EU.Create Tree When Do Subinventory Transfer (Doc ID 1281144.1)


On : 12.1.3 version, Material Move Orders

During the transact move order we experience the following issue, clicked select available inventory after lot allocation and tried to select a different lot than the one allocated by the system then entered a quantity of one and saved the record. We received the following error when hitting transact and reassessing the screen shows that the quantity of 1 became a quantity of 10.

Issue reported with the example of a dual UOM controlled item.

"Lot and/or Serial Number quantity does not match transaction quantity"

1. Launch the Pick Release for a sales order with a line of quantity 1
Once completed write down the move order number

2. Go to Transact Move Orders form
Query the move order number

3. In Transact Move Orders window:
See one move order line gest retrieved in Transact Move Orders window as expected
Check the Select check box and click Allocate
Click View/Update Allocations

4. In Move Order Line Allocations window:
Click Select Available Inventory to update allocations (i.e. choose another lot)

5. In Select Available Inventory window:
Clear the Selected Transaction Qty (1 EA) and Secondary Selected Qty (634 LB) for the allocated lot
Enter the same for the lot that you want to allocate
Click Done

6. You are back in Move Order Line Allocations window
Getting a Forms message box is shown with below message:
"FRM-40400: Transaction complete: 2 records applied and save."
Acknowledge the message

7. You are back in Transact Move Orders window
Click Transact
See an Error message box pops up with below message:
"Lot and/or Serial Number quantity does not match transaction quantity"
Click View/Update Allocations

8. In Move Order Line Allocations window:
See at the bottom Available primary and secondary quantities are now negative
Click Select Available Inventory

9. See the following in Select Available Inventory window:
  Transaction Qty: 1 EA
  Secondary Qty: 634 LB
  Transaction Qty: 10 EA ** instead of 1 EA
  Secondary Qty: 6340 LB ** instead of 634 LB


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

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