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

Last updated on APRIL 19, 2023

Applies to:

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

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