My Oracle Support Banner

When The Same Order is Shipped Partially Multiple Times in A Day, SOStatus Message Fails to Consume in RMS with Error "Both Customer Order Number and Fulfill Order Number Must be Defined for Customer Order Transfer %n" (Doc ID 2637999.1)

Last updated on MARCH 09, 2020

Applies to:

Oracle Retail Integration Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Integration Cloud Service (RICS) version 16.0.040.1

When the same order is shipped partially (multiple times in a day), SO Status message fails to consume in RMS with "Error from {call RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] Both customer order number and fulfill order number must be defined for customer order transfer %n."

Steps To Recreate:

1. Create a customer order having Single-Line multiple units ( C1 -> QTY 3)
2. Pick/Pack only ONE unit from the order
3. Check WMS->RMS->OB are updated with the Packed QTY of 1 unit (TSFHEAD.STATUS->P, OB->Picked)
4. Ship the unit now and again check WMS/RMS/OB/OMS are updated (<WMS SCHEMA>.ORDERHEADER -> Partly Allocated, TSFHEAD.STATUS -> S, OB -> Fulfilled, OMS-> Shipped Qty updated)
5. Now, only pick/pack the SECOND unit
6. Message is failed in RIB-RMS with the below error:
    javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] Both customer order number and fulfill order number must be defined for customer order transfer %n.

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
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.