Alc_shipping_schedule_path_levels=I,S Setting Does Not Work As Expected (Allocation 11.x Issue) (Doc ID 2002318.1)

Last updated on MARCH 26, 2017

Applies to:

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

Symptoms

In case of Alc_shipping_schedule_path_levels=I,S setup it is expected that the application uses the following logic:
If the expected record is found at the first level (in this case, item) then it uses that record. If the expected record is not found then it checks on the second level (in this case, subclass).

However, the application will raise a errors in the following 2 scenarios:

  1. Records at item level exist and records at subclass level do not exist
  2. Records at item level exist and records at subclass level also exist but are incorrect

 

Steps to Recreate:

Scenario 1 - Records at item level exist and records at subclass level do not exist

  1. Create alc_shipping_schedule records at item level only
  2. Select an item to be allocated
  3. Select a store
  4. Try to go to Rules page
  5. An error is raised: "No valid stores have been selected. To allocate, at least one store must be open and have a defined supply chain path. Please enter a valid store to continue."


Scenario 2 - Records at item level exist and records at subclass level also exist but are incorrect.

An example of incorrect setup at subclass level: the application cannot determine which path to select:

  1. individual path from DDC 9046 to Store 105
  2. individual path from RDC 9008 to Store 105
  3. individual path from RDC 9008 to DDC 9046
  1. Create alc_shipping_schedule records at item level
  2. Create alc_shipping_schedule records at subclass level as described
  3. Select an item to be allocated
  4. Select a store
  5. Try to go to Rules page
  6. An error is raised: "The item sources selected cross supply chain tiers. Allocations are limited to a single supply chain tier. Please remove conflicting records from the Review Items screen. Item source conflicts include:"

 

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