RPLATUPD Batch Aborts With Error: "ORA-00001: Unique Constraint Violated" (Doc ID 1945099.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1.7 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Merchandising System (RMS) 13.1.x, the RPLATUPD process aborts with the following error:


Steps to Reproduce:

  1. Find an item that does not have replenishment configured (i.e., does not exist in REPL_ITEM_LOC and does not exist in MASTER_REPL_ATTR).
  2. Navigate from the main menu:  Items > Replenishment > Replenishment Scheduled Update.  The Scheduled Replenishment Update Find window opens.
  3. Insert the item selected in step 1, select NEW in the Action combo box, and click OK.
  4. Configure the scheduled replenishment ACTIVATION parameters (the details of the replenishment are not relevant for this issue) for one location and select OK.
  5. Repeat the steps 2, 3 and 4, but instead of an ACTIVATION, schedule a DEACTIVATION for the same date and item/location combination.  When clicking OK, the application will give a warning saying that there is an existing scheduled update for this date/location/item combination. Select yes to confirm.
  6. Run the RPLATUPD process with VDATE equal to the scheduled date selected in steps 4 and 5.
  7. After running the RPLATUPD process verify that the item/location combination used in the previous steps does not exist in REPL_ITEM_LOC (but does exist in MASTER_REPL_ATTR).
  8. Repeat steps 2, 3 and 4 and schedule a new ACTIVATION for any date for the same item/location combination.
  9. Run the RPLATUPD process with VDATE equal to the scheduled date selected in step 8.  The process aborts with the error: ORA-00001: unique constraint (RMS13PRD.PK_MASTER_REPL_ATTR) violated~ARRAY INSERT: item XXXX.

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