My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.

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.

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.




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.