Allocated Quantity Is Incorrect For A Level 2 Sellable Item Which Is Not Part Of Any Pack (Doc ID 2061077.1)

Last updated on OCTOBER 06, 2015

Applies to:

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


Allocated quantity is incorrect for a level 2 item (which is not part of any pack) when allocated along with a level 2 item which is part of a case.  It allocates fine when only that item alone is allocated. To reproduce, ensure that this item should be shown as the 2nd item in the items screen. It is copying the case value of the other item and multiplying that value while generating this allocated Quantity which is incorrect. Also the store calculation multiple is defaulted to 'Case'.  If changed to 'Each' it gives the correct value.


Steps to recreate the issue:

 1)create item I1, with inner=1 and case=25
 2)create item I2 with inner=1 and case=1
 3)Insert some history for the items in ITEM_LOC_HIST
 4)start creating allocation , WHAT IF
 Add the above 2 items to the allocation
 5)In the items screen ensure the SCM(Store Calculation Multiple) is CASE
 6)Add store S1
 7)Use History rule sku level
 8)Calculate the allocation

 What is happening: it is taking the SCM of 25 of item I1 and applying it to both the items. So when this happens there is no issue for I1 but for item I2 the ALLOCATED_QUANTIY is 25 more then the need.

There are 2 issues

 Issue1: It is allocating 1 units of I1 , it should allocate 25 units
 Issue2: It is allocating 625 units of I2,it should only allocate 25 units


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