My Oracle Support Banner

Multi Level Distribution Allocations Fail to Integrate With ORWMS (Doc ID 1488356.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Retail Warehouse Management System - Version 13.2 and later
Oracle Retail Merchandising System - Version 13.2 and later
Oracle Retail Integration Bus - Version 13.2 and later
Oracle Retail Allocation - Version 13.2 and later
Information in this document applies to any platform.


Multi Level Distribution (MLD) allocations created using Oracle Retail Allocation application are failing to integrate with Oracle Retail Merchandising Systems (ORMS) & Oracle Retail Warehouse Management System (ORWMS).

Case 1: MLD allocation with 2 destinations, one of them passing by a tier:

Steps for this scenario:

  1. Create an allocation to two stores.
  2. Ensure the path above through Transit Times.
  3. Manually input the allocation.
  4. Calculate and approve the allocation.

Problem found at ORMS -> ORWMS integration:  The first allocation fails to integrate, because the Virtual WH (SODtlDesc.dest_id) is sent to ORWMS, which does not have information about Virtual Warehouses.

Flow : WH 1 ----> WH 2 ---> Store 1 


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.