My Oracle Support Banner

Allocation Uses DEFAULT_WH Data from WH_STORE_ASSIGN Table Instead of STORE Table (Doc ID 2040902.1)

Last updated on APRIL 11, 2022

Applies to:

Oracle Retail Allocation - Version 13.2.4 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


Problem Description

Oracle Retail Allocation is using DEFAULT_WH data from the WH_STORE_ASSIGN table instead of the STORE table.  When there is a mismatch in the tables due to users updating RMS to schedule a warehouse assignment change, Allocation picks up the warehouse from the wrong table.  As per the ranging validation logic present in Allocation, first the STORE table should be validated and then in case of no default warehouse defined for one or more stores, then it should look at the WH_STORE_ASSIGN table for any warehouses ranged to these stores in this table.


Steps to Recreate

Data Setup

store     assign_date     wh        processed_ind
1151      30-MAR-15       50001     Y

store     default_wh
1151      10001


  1. Search for items to allocate: find an item that is stocked at two warehouses.
  2. Select the stock from WH 10001.
  3. Add store 1151 in the Locations screen.  Keep 'Enforce Store-Warehouse Relationship' selected.  Click 'Next'.
  4. Note the pop up message:  No valid stores have been selected.
  5. Uncheck 'Enforce Store-Warehouse Relationship'.  Click Next.
  6. Enter rules and save. 
  7. Go to Search for Items to Allocate.
  8. Search for the item in Step 2.
  9. Select the stock from WH 50001.
  10. Add store 1151 in the Locations screen.  Keep 'Enforce Store-Warehouse Relationship' selected.  Click 'Next'.
  11. Note that there is no error message, and the Rules screen comes up.  
  12. Note: Allocation is using the WH from the WH_STORE_ASSIGN table and not the DEFAULT_WH from the STORE table.


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.