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 01, 2023

Applies to:

Symptoms

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

Error:

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.

Cause

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