"ORA-00001 : Unique Constraint PK_DEAL_ITEM_LOC_EXPLODE Violated" Error If a Deal Is Edited (Doc ID 2189733.1)

Last updated on OCTOBER 04, 2016

Applies to:

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

Symptoms

The following error occurs when attempting to edit an approved deal by bringing it back to worksheet status:

 
Steps to Reproduce:

  1. Go to Deal Maintenance [dealmain] screen and create a new deal.
  2. Add one item location and approve the deal by selecting Options -> Submit and then Options ->Approve.  Press Save. Do not close screen.
  3. Now bring the deal back in worksheet status and add the same item again for a different location.
  4. Approve the deal and press Save. Close the screen.
  5. Check data in COST_EVENT and COST_EVENT_DEAL tables and note that two process ID's have been generated.
  6. Run deal batches.
  7. Note the error in COST_EVENT_RESULT table.

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