Calcutaion of Available To Reserve Quantity On Material Workbench After Sales Order Reservation (Doc ID 1485807.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Warehouse Management - Version 11.5.10.CU2 and later
Information in this document applies to any platform.
***Checked for relevance on 6-OCT-2014***

Symptoms

On : 11.5.10.2 version,

Available to Reserve quantity is wrong on Material Workbench after sales order (OM) reservation.

After creating a reservation for a sales order line, the available to reserve quantity is wrong.

Scenario:

A) Before reservation

Subinventory: 1 - Item Location: AA - Lot number: 600065
- On hand: 1.43
- ATR: 1.43
- ATT: 1.43

Subinventory: 1 - Item Location: BB - Lot number: 600065
- On hand: 8.58
- ATR: 8.58
- ATT: 8.58

Subinventory: 2 - Item Location: CC - Lot number: 600065
- On hand: 1.0725
- ATR: 1.0725
- ATT: 1.0725

----
 Reservation created: quantity 5.72 - Lot number: 600065
----

B) After reservation

Subinventory: 1 - Item Location: AA - Lot number: 600065
- On hand: 1.43
- ATR: 1.43
- ATT: 1.43

Subinventory: 1 - Item Location: BB - Lot number: 600065
- On hand: 8.58
- ATR: 5.3625
- ATT: 5.3625

Subinventory: 2 - Item Location: CC - Lot number: 600065
- On hand: 1.0725
- ATR: 1.0725
- ATT: 1.0725

There are no move orders and no other reservations.

Questions:
- Why ATR and ATT quantity did not change to 2.86 (8.58 minus 5.72)?
- Where is the difference between the reservation (5.72) and the quantity reserved (3.2175)?

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