How is Available To Reserve Calculated For Locator-Controlled Items? (Doc ID 1383892.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

To explain how Available To Reserve (ATR) and Available To Transact (ATT) are calculated.

The confusion comes in situations like the following where a quantity has been over issued from another locator:

1. Create a Misc Receipt of
Item : A
Qty : 100
Lot No : Lot1
Subinv : SubinvA
Locator : Locator1

2. Create a Misc Receipt of
Item : A
Qty : 100
Lot No : Lot1
Subinv : SubinvA
Locator : Locator2

3. Create a Misc issue of
Item : A
Qty : -200
Lot No : Lot1
Subinv : SubinvA
Locator : Locator 1

4. Now On hand quantity (OHQ) is
Subinv --SubinvA
loc -- Locator1 IS
onhand : -100
ATR : -100
ATT : -100


Subinv : SubinvA
Loc : Locator2 IS
Onhand : +100
ATR : 0
ATT : 0

 Why is the ATR,ATT at Locator level showing as '0' when Locator2 still has stock ?

Solution

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