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 20, 2024

Applies to:

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

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