Item Search : "There Is Already A Row Of "COUNTRY" With "COUNTRY" As "&ATTR1_VALUE". (Doc ID 2731117.1)

Last updated on NOVEMBER 25, 2020

Applies to:

Symptoms

On : 12.1.3 version, User Defined Attributes

When attempting to add a new Country to the UDA list, click Add another row and Add a different 16th country > click Apply
the following error occurs.

ERROR
-----------------------
Error message: "There is already a row of "COUNTRY" with "COUNTRY" as "&ATTR1_VALUE". Please enter a distinct value for "COUNTRY".(ATTR1_VALUE=)".


STEPS
-----------------------
Steps to re-produce the issue with screen prints:
Item Catalog
Come to this screen by searching item – Specifications
Scroll Down on same screen to see countries, here 13 countries already there.
Already added countries screen print is given below for clarity, before I start adding 14th, 15th and 16th country.
Now try below steps in strict order, here we are adding 3 countries and their codes
are XX, YY, ZZ (Note: these are not in list of 13 countries already added).

Update Mode: Click on button “Add Another Row” and enter code XX , ** Note
didn’t press tab nor magnifying lens here. No error till this point. And country count is now 14.

Click on button “Add Another Row” and enter code YY, ** Note didn’t press
tab nor magnifying lens here. No error till this point. And country count is now 15.

Click on button “Add Another Row” and enter code ZZ, ** now pressed tab,
press magnifying lens. And country count is now 16.
Error created at this point – Error message: "There is already a row of "COUNTRY" with "COUNTRY" as "&ATTR1_VALUE". Please enter a distinct value for "COUNTRY".(ATTR1_VALUE=)".

Changes

Cause

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