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

Last updated on SEPTEMBER 11, 2019

Applies to:

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

Cause

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