When Using Dutch Locale, Three Decimal Place Values Change To Thousand Separator Values For Presentation Variable Prompt (Doc ID 2732374.1)

Last updated on DECEMBER 25, 2022

Applies to:

Symptoms

When prompt value with three decimal place (eg., 'x,xxx') entered in Dashboard prompt, it's being taken as thousand separator instead of decimal point and shown as 'xxxx,x' when using dutch locale.

In Dutch localization (nl-nl), a period '.' is used as a thousand separators and a comma ',' to indicate the decimal point.

Steps to reproduce:

• Create a Dashboard with report and Dashboard prompt with two variable prompts (v_xxx, v_xxxx) with Textbox type User input
• Add the above presentation variables to report filter using 'inBetween' condition
• Enter Decimal Place values (eg., 'x.x' , 'x.xx', 'x.xxx' ) in prompt textboxes and Click Apply. Dashboard Report is showing correct data
• Change the Locale to Dutch (Netherlands - Netherlands) in 'My Account > Preferences' and save 'Preferences'.
• Open the Dashboard again. Enter values with 1 or 2 decimal places ('x,x', 'xxx,xx') in prompt textbox and Click Apply. Report is showing correct data
• Enter three decimal place values (eg., 'x,xxx' & 'xxx,xxx') in prompt and Click Apply. Values in prompt textboxes are changed with thousand separator instead ( 'xxxx,x' & 'xxxxx,x') and Filtering in report shows for values 'xxxx' & 'xxxxxx'
• Again Enter four Decimal place values (eg., 'x.xxxx' & 'xxx.xxxx') in prompt and Click Apply. Report is showing correct data even if the last decimal is 0.

This issue is only occurring with three decimal place values for prompt with presentation variables and in Dutch locale.

Cause

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