Negative Available To Reserve (ATR) Issue For Move Order Allocations (Doc ID 416653.1)

Last updated on FEBRUARY 09, 2016

Applies to:

Oracle Warehouse Management - Version 11.5.10 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 08-SEP-2014***

Symptoms

On 11.5.10:
Find negative ATR issue which comes because of the combination of organization level reservations and pending move order allocations. The is causing negative ATR ATT see the following test case.

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

1) Created an Item called TEST ATR
2) Do a Account Alias receipt of 100 in a
Subinventory = 1100P
Locator = SMI100A1
3) ATR/ATT picture is as follows
OHQ = 100
ATR = 100
ATT = 100
4) Create a sales order for the above item for a quantity of 20 for a date of
06-Nov-06
5) Booked the order
6) Scheduling goes through fine.

7) Reservation program goes through fine and places an org level reservation=20
8) ATR/ATT picture is as follows
OHQ = 100
ATR = 80
ATT = 80
MTL_RESERVATIONS table would have an org level reservation for qty = 20
9) Create a replenishment move order to transfer a quantity of 100
From Subinventory = 1100P To Subinventory = 1200P
Quantity = 100
10) Allocated the above move order. Allocation went through fine
11) ATR/ATT picture is as follows
OHQ = 100
ATR = -20
ATT = -20
MTL_RESERVATIONS table would have an org level reservation for qty = 20
MTL_MATERIAL_TRANSACTIONS_TEMP would have an allocation of qty = 100 with
FROM_SUBINVENTORY = 1100P and TO_SUBINVENTORY = 1200P
12) You can see the above negative availability coming because the quantity
tree logic is considering the move order allocation of 100
ATR = OHQ - RES - MMTT = 100 - 20 - 100 = -20

Reservations program should not consider the sub transfer allocations.

13) If we create another sales order with a qty = 30 then scheduling would go
through fine and give a scheduled ship date

14) But the reservations program would fail with the following message
"Quantity on hand fails to satisfy reservations"




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