Upload Error 'Item And Image Name With This Priority Value Already Exists.' When At The Style And SKU Level There Are Different Image Names. (Doc ID 2968628.1)

Last updated on AUGUST 18, 2023

Applies to:

Symptoms

Getting an upload error 'Item and Image name with this priority value already exists.' when at the Style and SKU level there are different image names.


ERROR
-----------------------

'Item and Image name with this priority value already exists'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Item master template for item upload where in the Item images tab you have images specified both for the Styles and SKUs. (Check the Item Images tab in our example file which is a customer specific template but this tab is a standard one: We have 2 styles with multiple SKUs in the file. For one of the Styles (LCHK6) the same image names/display priorities were added to the style and also to all of the related 5 SKUs. For the other Style (QXNGV) there are 7 image names and for the SKUs, we want to set up other images, eg only 2 images for a SKU)
2. Upload the file
3. Observe that an error message is given for the QXNGV related SKUs: Item and Image name with this priority value already exists. See attached the Item Induction issues (18) file.
4. Observe that for the other items, there's no error, the items are created in Approved status and the same images are added to the Style and SKUs.

In the example above, the Cascade of Image Inherit on child/grandchild Indicator was set to Yes. When it was set to 'No', for the same file we also get an Error ORA-00001: unique constraint (RMS01.PK_ITEM_IMAGE) violated returned by program unit CORESVC_ITEM.EXEC_IIM_INS. (see attached Item Induction issues (17) file)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.