The Error Does Not Tell Which Records Are Duplicate When Multi-Row Attribute Group Has 6 Key (Doc ID 2050900.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Actual Behavior

When entering a duplicate record to multi-row attribute group which has 5 unique key, the following error occurred.
The error tells the user which records are duplicate entries.  
 
---------------------------------------------------------
FND_NEW_MESSAGES
MESSAGE_NAME : EGO_EF_UK5_VIOLATION
MESSAGE_TEXT :
  There is already a row in "&AG_NAME" with "&UK1_NAME" as "&ATTR1_VALUE","&UK2_NAME" as "&ATTR2_VALUE", "&UK3_NAME" as "&ATTR3_VALUE", "&UK4_NAME" as "&ATTR4_VALUE", and "&UK5_NAME" as "&ATTR5_VALUE".  
  Please enter a distinct combination of values for "&UK1_NAME", "&UK2_NAME", "&UK3_NAME", "&UK4_NAME", and "&UK5_NAME".
---------------------------------------------------------

However, when entering a duplicate record to multi-row attribute group which has more than 6 unique key, the following error occurred.
 
---------------------------------------------------------
FND_NEW_MESSAGES
MESSAGE_NAME : EGO_EF_LONG_UK_VIOLATION
MESSAGE_TEXT :
  There is already a row in "&AG_NAME" with the same combination of values for the following fields: &UK_NAME_LIST.  
  Please enter a distinct combination of values for all fields that uniquely identify a row of data.
---------------------------------------------------------
 
In both situation, the multirow unique value validation is throwing this error correctly.
But the problem is that the error does not tell the user which records are duplicate entries when multi-row attribute group has more than 6 unique key.



Expected Behavior

The error should tell the user which records are duplicate entries even if multi-row attribute group has more than 6 unique key.

 

Steps To Reproduce

  1. Search item and click on item page which have multirow attribute group with more than 6 Unique Keys.
  2. Add a new row with the same Unique key values for which already there is an existing entry.
  3. The multirow Unique Value validation is throwing the above error correctly. But the error does not tell the user which records are duplicate entries.

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