"ORA-00001: Unique Constraint (RMS14.PK_ITEM_LOC) Violated" Error Occurs When Item Is Ranged Through XItemLoc

(Doc ID 2001172.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.0.1 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.


When attempting to range a complex pack item through the XItemLoc message, the following error occurs:

Steps to Reproduce:

  1. Create a complex pack, non-orderable, without a supplier through RMS.
  2. Range the item through XItemLoc. Ensure it is on District level and not at store/warehouse level.
  3. Note the error.


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