My Oracle Support Banner

Updating Multi Row User Defined Attributes With Just One Row Error "&Attribute_Group lacks a defined combination of fields whose values would uniquely identify a row of data" When Unique Key Is Not Defined (Doc ID 2867583.1)

Last updated on MAY 05, 2022

Applies to:

Oracle Product Hub - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

User has a multi-row attribute group with just one record of data. When updating this record from Item Overview > User defined attribute page, an error is thrown. This is not expected. User should be able to maintain one row without defining a unique key for the attribute group. Unique key will be required only when there are more than one records in the attribute group.

Error
-------
"&Attribute_Group" lacks a defined combination of fields whose values would uniquely identify a row of data for "&Attribute_Group" (i.e., a Unique Key). Please ask your system administrator to fix this problem.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Development manager > Item Simple search > Search for item with multirow attribute group > Item: ABC100
2. Open Multi-row attribute group page > Click on Update > Try to update first record > See error.

Workaround
-------------
Remove the newly added empty record and then, try to update the first record. This will not cause any errors.
However, empty records should not be validated as the second record as user has not entered any data.

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.