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

(Doc ID 2133337.1)

Last updated on FEBRUARY 01, 2018

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Oracle Supplier 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

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
7. Update the first value to 1234564.
8. Save
9. Throws again the same error even though the values are different


Changes

 

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