Warehouse Based Allocation Allocates Greater Quantity Than Available Quantity (Doc ID 1950005.1)

Last updated on MAY 08, 2016

Applies to:

Oracle Retail Allocation - Version 13.2.6 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Allocation 13.2.6, warehouse-based allocation with Proportional Need is allocating more quantity of packs than the Available Quantity.  Allocated Quantity cannot be more than Available Quantity.  In the logs, the calculation engine is allocating [+ve] and [-ve] quantities.  The sum of all the quantities it is equal to Available Quantity. The correct available quantity is passed to the calculation engine.


Steps to Reproduce:

  1. In Item search screen, select Warehouse source.
  2. Enter Pack ID and hit search.
  3. Select Item and click create allocation.
  4. Select locations using location list with around 600 locations.  Uncheck option "Enforce Store-Warehouse relationship"; Click next.
  5. On rule page, use rule as History, Hierarchy as SKU, Type Need is Proportional; provide date range. Select Fiscal week (Regular sales).
  6. Hit Calculate button.
  7. Once calculated, open Calculation summary page and validate Available vs Allocated Quantities. Allocated Quantity is greater than Available Quantity.

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