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