My Oracle Support Banner

Split Container Does Not Clear PO_NBR in Container and This Fails INV_ADJ Message With "Error From {Call RMSSUB_INVADJUST.CONSUME (?,?,?,?)}: [E] There are no Viable Warehouses For Distribution" Error (Doc ID 2774796.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

Oracle Retail Warehouse Management System - Version 16.0 and later
Information in this document applies to any platform.


When attempting to apply trouble to the Container,
the following error occurs.


Steps To Recreate:
 1.Create 2 purchase orders with different items.
    PO A with Item A and PO B with Item B.
2.Receive both PO.
3.Perform split container from the container that contains: Item A (PO A) to the container that contains: Item B (PO B).
4.Validate that the container has PO_NBR and that the CONTAINER_ITEM has 2 different items.
5.Apply trouble code to the container.
6.Check INV_ADJUSTMENT_TO_UPLOAD_HIS table, the items were sent to RMS with PO_NBR
7.IN RMS SYSTEM,verify that the inventory adjustment message failed in the hospital and causing a difference between the stocks of the systems.


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.