My Oracle Support Banner

Receiving Messages Are Failing In RIB With Error - No Viable Warehouses For Distribution (Doc ID 2437904.1)

Last updated on MARCH 02, 2019

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 to 16.0.1 [Release 16.0]
Information in this document applies to any platform.

Symptoms

Receiving a Purchase Order (PO) line Item on a different Virtual Warehouse (Wh) location of a different Physical Wh through the RIB throws the following error:

Error
-----------------------
"javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] No viable warehouses for distribution."


Steps to Reproduce:

  1. Create and approve a PO (PO1) with an Item (Item1) and Warehouse  location (VWH1 of Physical Warehouse  Wh1).
  2. Make sure Item1 is ranged to a different Warehouse also VWH2 of Physical Warehouse  WH2.
  3. Make sure there is no other Virtual Warehouse  for Physical Warehouse  WH2 (WH2 only have one Virtual Warehouse, VWH2) in the ITEM_LOC table.
  4. Perform a Receiving through the RIB for PO1 and Item1 and Location WH2.
  5. The RIB message will go to the hospital with the following error:
    "JAVAX.EJB.EJBException: Exception while processing request: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] No viable warehouses for distribution. at    com.RETEK.RIB.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(RIBMESSAGESUBSCRIBEREJB.JAVA:406)"

     

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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