My Oracle Support Banner

Different Allocations Results Based On Use Of Default Sourcing Location Only Flag (Doc ID 2716722.1)

Last updated on NOVEMBER 04, 2020

Applies to:

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

Symptoms

When allocating one or more "NON SELLABLE FASHION PACK" using "SIMPLE" method at "STYLE-COLOR" level we are getting different results based on if the flag Use Default Sourcing Location Only is checked or not.

System_options configuration for "LOCATION EXCEPTION REASONS" is currently set as C D I.

The results can vary depending on the configuration of the packs being distributed. It can either send 0 quantities even with "high" need or be the difference of sending 4 of pack "A" or 3 of pack "A" and 1 of pack "B".

For example in one scenario with:

- Allocating 1 PACK with a 12 size.
- 2 Stores.
- History with no data.
- Adding "30" as min gross need.
- Using the flag "Use Default Sourcing Location Only" - Getting 2 valid stores.
- Stores with no stock on hand.
- Allocating to NET NEED.

Results:
- Gross Need: 30.
- Net Need: 30.
- Final: 36 (OK).

But now if we change the flag so it's unchecked. So we get:
Results:
- Gross Need: 30.
- Net Need: 30.
- Final: 0 (NOT OK).

Other scenario is:
- Allocating 2 PACKS with a 8 and 5 size.
- 2 Stores.
- History with no data.
- Adding "30" as min gross need.
- Using the flag "Use Default Sourcing Location Only" - Getting 2 valid stores.
- Stores WITH stock on hand
- Allocating to GROSS NEED

Results:
- Gross Need: 30.
- Net Need: -36 and -182.
- Final: 32. Of which it distributed 4 of Pack "A" (size 8)

Changing the FLAG we get:

Results:
- Gross Need: 30.
- Net Need: -36 and -182.
- Final: 29. Of which it distributed 3 of Pack "A" (size 8) and 1 of Pack "A" (size 5)

-----------------------------

This flag should have an impact on distribution since it should only limit the supply chain availability.
This type of behavior leads to uncertainty among the users as they feel the system is not reliable on the calculations.
We expect the calculation to be the same regardless of the use of this flag, it should only be affected by other flags or values especially values on Limits or Rules.

Cause

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
Symptoms
Cause
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.