Sending Xorderlocexpcre - Unique Constraint Violation
(Doc ID 2871302.1)
Last updated on JANUARY 10, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and laterInformation in this document applies to any platform.
Symptoms
Sent a RIB Message to create an OrdLoc Expense.The expense was not created and got this error message on RMS RIB Hospital:
ERROR
-----------------------
javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_XORDER.CONSUME(?,?,?,?)}: [E] Error ORA-00001: unique constraint (RMS01.UK_ORDLOC_EXP) violated returned by program unit CORESVC_PO.EXEC_ORE_INS.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Send a XOrderLocExpCre message using Rib-Ext (message attached on xorderlocexpcre_msg.xml)
2. See the issue on RMS RIB-Hospital
The Ordloc_Exp table has a record for:
Order 10010144483 - Item 5101011596078 - Pack Item 100045082
But not for:
Order 10010144483 - Item 5101011596078 - Pack Item NULL
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 |