The RMS DITINSRT Batch Aborts with Error "Unique Constraint (RMS.PK_DEAL_CALC_QUEUE) Violated" Error (Doc ID 1348763.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 to 13.2.7 [Release 13.2]
Oracle Retail Merchandising System - Version 13.1.3 to 13.1.4.3 [Release 13.1]
Information in this document applies to any platform.

Symptoms

The Retail Merchandising System (RMS) DITINSRT (Deal Item Insert) batch aborts with the following error:

ditinsrt_1~20110609002708~insert_deal_calc_queue~deal_calc_queue~-1~ORA-00001: unique constraint (RMS.PK_DEAL_CALC_QUEUE) violated~ARRAY INSERT: order_no=..


Steps to Reproduce:

  1. Create a deal.
  2. Run DITINST batch.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms