Data Picker Window Not Returning Results When the Date Format Selected in the User's Preference Is Not YYYY-MM-DD (Doc ID 2811124.1)

Last updated on JUNE 28, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR

A Data Picker has been configured from Business Process (BP) X to pick records from BP Y. the picker window does not display any results and processing does not end.
 
STEPS TO REPRODUCE

1. Login Unifier
2. Navigate to the impacted workspace
3. Create
4. Go to the data picker in upper form and try to select an entry from the window that pops up
5. Observe that there areseveral records , but the record details are not showing

ADDITIONAL INFORMATION

F12 log showing the error : Uncaught Error: The string 2020-05-13 00:00:00.0 is not a valid ISO 8601 string syntax.
  at Object._throwInvalidISOStringSyntax (main.js?v=21.6:496)
  at Object._IsoStrParts (main.js?v=21.6:496)
  at Object._isoToLocalDateIgnoreTimezone (main.js?v=21.6:496)
  at Object.isoToLocalDate (main.js?v=21.6:496)
  at Object.isoToLocalDate (main.js?v=21.6:496)
  at s.format (main.js?v=21.6:1202)
  at r.format (main.js?v=21.6:1202)
  at r.create (main.js?v=21.6:1195)
  at d.makeCell (main.js?v=21.6:1195)
  at d.makeRowGroupSegment (main.js?v=21.6:1195)

Check the user's Preferences and find that the date format is DD/MM/YYYY. However the date format for the Data Picker is YYYY/MM/DD.

EXPECTED BEHAVIOR

The records should show when the user clicks on the Data Picker.

Cause

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