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:

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

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