User Defined Attributes (UDA) With Value Set Having Table Validation Shows Wrong Date Format YYYY-MM-DD, But Correct With Dependent Valueset or Without Valueset: MM/DD/YYYY

(Doc ID 2262266.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
User Defined Attributes (UDA)
Table Validation Valueset
Date Format YYYY-MM-DD
Independent Valueset
MM/DD/YYYY

Symptoms

User defined attributes with date format and value set incorrectly displays in format "YYYY-MM-DD". ( Example date: 2017-03-30 00:00:00.0 )

WHAT IS WORKING
Works fine if there is no value-set attached to the user defined attribute (Example date: 03/30/2017).
Works fine if there is a value-set but the validation is independent. (Does not work only when the validation type is Table.)

EXPECTED BEHAVIOR
Expect format: MM/DD/YYYY ( Example date: 03/30/2017)

STEPS
1. Search for item.
2. Review user defined attribute.
3. See wrong date format.

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