MDO/COE Weekly Load Failure with Error 'The value in WAREHOUSE_KEY in the distribution center allocation table (ASH_DC_ALLOCATION_TBL) does not exist in WAREHOUSES_TBL (as WAREHOUSE_CLIENT_ID).' (Doc ID 2063380.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Retail Clearance Optimization Engine - Version 13.0.0 and later
Oracle Retail Markdown Optimization - Version 12 and later
Information in this document applies to any platform.

Symptoms

The weekly processing failed with the following error description in the ASH_DC_ALLOCATION_TBL_BAD:
The value in WAREHOUSE_KEY in the distribution center allocation table (ASH_DC_ALLOCATION_TBL) does not exist in WAREHOUSES_TBL (as WAREHOUSE_CLIENT_ID).

Example from ASH_DC_ALLOCATION_TBL_BAD:
DESCRIPTION:    The value in WAREHOUSE_KEY in the distribution center allocation table (ASH_DC_ALLOCATION_TBL) does not exist in WAREHOUSES_TBL (as WAREHOUSE_CLIENT_ID).
ERROR_TIMESTAMP   WAREHOUSE_KEY     MERCHANDISE_KEY     MERCHANDISE_LEVEL      LOCATION_KEY     FRACTION
5-OCT-15                  513                         654                             SUBCLASS                     5050                    0.932845

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