ORA Error Occurs When Order Cancel API Is Triggered After Order Is Reveived At Store B
(Doc ID 2905482.1)
Last updated on OCTOBER 27, 2022
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
Customer order initiated at Store A. Store A does not have sufficient quantity. Therefore internal transfer between Store B to Store A occurs. Item is shipped and received from Store B to Store A. Now the customer wants to cancel the order. When order cancellation request sent to RMS an ORA error occurs stating ITEM_LOC_SOH.CUSTOMER_RESR cannot be brought to null.
ERROR
-----------------------
javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_FULFILORD.CONSUME(?,?,?,?)}: [E] Error ORA-01407: cannot update ("RMS01"."ITEM_LOC_SOH"."CUSTOMER_RESV") to NULL returned by program unit CORESVC_FULFILORD_TSF.UPDATE_CUST_RESV.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Customer order is allocated for Item A 2 qty at Store B (Store to Store type CO)
2. CO is created and an internal transfer is created from Store A to Store B.
3. Transfer is shipped from Store A to Store B
4. Transfer is received from Store A to Store B.
5. Order cancellation initiated at Store B.
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 |