My Oracle Support Banner

Wrong Total Net Need In The Review Section (Doc ID 2059665.1)

Last updated on APRIL 11, 2022

Applies to:

Oracle Retail Allocation - Version 14.0.2 to 14.1.3 [Release 14.0 to 14.1]
Information in this document applies to any platform.


Scenario 1

The Total Net Need in the Review Section is incorrect.

  Net Need ST1: 1397
  Net Need ST2: -260

The results section shows the values above which is correct, however the Total net need displayed in the review section and saved in the DB table alc_item_source is not correct.
Actual value: 1137 (1397-260)
Expected value: 1397

Steps to recreate

1. Create an Allocation with 2 stores where the net need of one of them is negative and for the other positive
2. Validate that Review section is not showing the right Total Net Need Qty

Scenario 2

Allocation shows -1 Allocated.  Negative Quantities are allocated to packs.  The issue occurs when selecting All Stores.  It does not happen if a new allocation is created with just the stores that had negative quantities.

Steps to Reproduce

1. Create an Allocation
2. Choose a pack to allocate.
3. Select All Stores
4. Calculate
5. Note that -1 is allocated to some stores.

If you create a new allocation with the same packs and select just some of
the stores that had -1 allocated, they are correctly allocated 0.





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

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