My Oracle Support Banner

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


Sent a RIB Message to create an OrdLoc Expense.The expense was not created and got this error message on RMS RIB Hospital:

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.

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


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.