My Oracle Support Banner

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

Last updated on APRIL 04, 2025

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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