Need To Understand The Priority Of Reservation Quantity Transfer Which Happens During Onhand Receipt (Doc ID 2764045.1)

Last updated on MARCH 31, 2021

Applies to:

Goal

On : 12.1.3 version, Reservations

What is the priority of Reservation quantity transfer which happens during Onhand receipt?

Scenario

---------

Two demands are created for Inventory and Sales order having same PO as Supply.

1. Create a PO# 123 for item# A, qty = 1000.
2. Create a SO# 10 for the same item# A, qty = 200.
3. Let us suppose current on-hand of item = 1000
4. Go to Inventory > Reservations. Create below entries -

        Entry #1

1. Demand type = Inventory, need-by-date = 29-MAR-2021, qty = 500
2. Supply type = PO, need-by-date = 29-MAR-2021, qty = 500
3. On-hand = 1000
4. Available = 1000

        Entry #2

1. Demand type = Sales Order, need-by-date = 29-MAR-2021, qty = 200
2. Supply type = PO, need-by-date = 29-MAR-2021, qty = 200
3. On-hand = 500
4. Available = 500
5. Ordered = 200

        5. Now, receive PO# 123 for qty = 200

        6. You will below changes in Reservations -

        Entry #1

1. Demand type = Inventory, need-by-date = 29-MAR-2021, qty = 500
2. Supply type = PO, need-by-date = 29-MAR-2021, qty = 500
3. On-hand = 800
4. Available = 800

         Entry #2

1. Demand type = Sales Order, need-by-date = 29-MAR-2021, qty = 200
2. Supply type = Inventory, need-by-date = 29-MAR-2021, qty = 200
3. On-hand = 1200
4. Available = 700
5. Ordered = 200

You can see the supply reservation is changed to inventory and reservation quantity is transferred to sales order

Solution

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