My Oracle Support Banner

ReSA Total on v19.3.012 Frozen and Then Returned a PK_SA_VR_HEAD Unique Constraint Violation (Doc ID 2908061.1)

Last updated on NOVEMBER 09, 2022

Applies to:

Oracle Retail Merchandising System - Version 19.0 and later
Information in this document applies to any platform.


ReSA total freezes following an update to 19.3.012. Customer found sever Realms had already been populated including SA_TRAN_ITEM and V_SA_TRAN_ITEM_DISC_NET.

The application froze when the customer attempted to select the next tab, they waited, then closed tab and restarted ReSA.

Following this customer received error PK_SA_VR_HEAD unique constraint violation.


 Update to 19.3.012.


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.