Item Supply/Demand Is Not Properly Working For Move Order Allocation And Move Order Supply (Doc ID 1407620.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Symptoms

On the Inventory Supply Demand form 12.1.1 version:

Find that the onhand available quantity is increased by the Move Order Supply quantity but it is not reduced by the Move Order Allocation quantity in the form.

For a specific item, there is Current On-hand of 1828 and a Purchase Order (Supply) of quantity 1350 so the total on-hand available quantity is 3178.

There are 2 Move Order Allocations with quantities of 500 and 335.

In this case, the Item Supply/Demand form should show an onhand quantity of: 3178 - (500+335) = 2293.

However, the Move Order Allocation is not deducted and it is adding the Move Order Supply as 835.  This results in an onhand quantity of 4013 which is incorrect. 

The screenshot below illustrates the example as mentioned above:



EXPECTED BEHAVIOR
-----------------------
Expect that the Move Order Allocation lines are deducted from the Available Quantity

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility :Inventory
2. Navigation :Onhand availability > Item supply /demand form
3. Note the unexpected increase in onhand quantity

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Cannot properly use the item supply/demand form

Cause

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