Incorrect Unique Value Validation Thrown For Multi-Row User Defined Attributes (UDA)
(Doc ID 2133337.1)
Last updated on SEPTEMBER 11, 2019
Applies to:
Oracle Product Hub - Version 12.1.3 and laterOracle 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
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 |
Cause |
Solution |
References |