My Oracle Support Banner

SIOCS Sent Multiple CRE Messages For The Same RTV (Doc ID 2956314.1)

Last updated on JUNE 20, 2023

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 23.1 and later
Information in this document applies to any platform.


SIOCS is sending multiple RTVCre messages for the same RTV.

This fails in MFCS with the following error:

 "[E] Error ORA-00001: unique constraint (RMS01.PK_RTV_HEAD) violated returned by program unit RTV_SQL.BUILD_RTV_APPRV."

The customer was not able to replicate this or know of anything in particular that was done differently when this RTV was created. This was the only failure in over a thousand tests.

To recover the messages, can they remove the one failing so the next one is consumed (it's also a CRE, but it has the shipment for the RTV)?


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.