Unexpected Validation Error When Numbers Are Over 1,000 (Doc ID 2344389.1)

Last updated on SEPTEMBER 13, 2022

Applies to:

Symptoms

An ADF application has a page listing records from a DB table.

The records can be navigated through table pagination.

The table is based upon a View Object which has an attribute of type Big Decimal which UI Hints define the runtime display format to "###,###,##0.00".

More specifically the View Object code is similar to the one below

ACTUAL BEHAVIOR
------------------
At runtime, when navigating through the records, for records having <VO_ATTRIBUTE_NAME> with a "," separator (i.e. 1,000.00 or higher), the UI will report a validation error and navigation stops, unless the value is edited and changed to one without ",".

EXPECTED BEHAVIOR
------------------
"###,###,##0.00" is a legal Big Decimal format and should not break UI functionality.

Changes

Cause

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