Incorrect Unique Value Validation Thrown For Multi-Row User Defined Attributes (UDA) (Doc ID 2017581.1)

Last updated on MAY 02, 2016

Applies to:

Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Oracle Supplier Hub - Version 12.1.3 and later
Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

For a multi-row UDA, the unique validation throws an error even if the values are unique.

ERROR
-----------------------
Error
There is already a row of "Attr1_num" with "XYZ1 Global Company Prefix (XYZ)" as "1234567". Please enter a distinct value for "Attr1_num".

Debug log:
----------
getProfileOptionValue: name=ICX_CLIENT_IANA_ENCODING; levelID=10001; levelValue=0; levelValueApplID=0
OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: There is already a row of "XYZ1 Global Company Prefix (XYZ)" with "XYZ_TEST" as "23". Please enter a distinct value for "XYZ_TEST". ,In VO: null
OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: There is already a row of "XYZ1 Global Company Prefix (GCP)" with "XYZ_TEST" as "23". Please enter a distinct value for "XYZ_TEST".
getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10004; levelValue=1150; levelValueApplID=0
getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10003; levelValue=50638; levelValueApplID=177
getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10002; levelValue=177; levelValueApplID=0
getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10001; levelValue=0; levelValueApplID=0
OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: There is already a row of "XYZ1 Global Company Prefix (XYZ)" with "GCP_TEST" as "23". Please enter a distinct value for "XYZ_TEST". ,In Bean: null
getProfileOptionValue: name=FND_CUSTOM_OA_DEFINTION; levelID=10004; levelValue=1150; levelValueApplID=0
.
.
  whereParam3: N
  orderByClause: EXTENSION_ID ASC
  ViewUsageName: POS_SUPP_PROFMGMT_GROUP177XXSM_COMMUNICATIONSUPP_LEVEL
  isPreparedForExecution: true


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a number UDA Attr1_num
2. 1234567 is added.
3. Click Save.
4. 1234567 again added
5. Save
6. See the error:
Error
There is already a row of "Attr1_num" with "GS1 Global Company Prefix (GCP)" as "1234567". Please enter a distinct value for "Attr1_num".

7. Update the first value to 1234564.
8. Save
9. Throws again the same error even though the values are different


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