My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

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 5 unique keys, 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 5 unique keys.

Expected Behavior

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

Steps To Reproduce

  1. Search item and click on item page which have multirow attribute group with more than 5 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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