Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number Field Item / IG Number Column: Bug with Format Mask when App language not English (Apex 21.1)

user11980020Jun 8 2021

Hello,

I've found a bug in APEX 21.1. I tested in browsers Edge Chromium and Firefox.

Application Language is German (Germany), not English (United States).

A NUMBER FIELD ITEM in a Form Region,
that has a Format Mask for example like 999G999G999G990, that is without decimals,
shows some wrong behavior:

If the value is between 1000 and 999999 then the Group Separator is treated as the Dezimal Separator, Value => Value/1000.

For example:
1200 becomes 1
999999 becomes 1.000 (=1000)
17600 becomes 18

This appears on displaying the value and on saving changed values, wrong value is saved in table! In worst case value is so changed twice.

No problem with smaller Number (<1000)
No problem with longer Number, that would have several Group Separators.
No problem with a Format Mask with decimals (for example 999G999G999G990D00)

Interactive Grid:
On new created app, there are also similar problems with editable number column with such a format mask in IG, when it is in edit mode.

I would be happy if this could be solved. New apex features are great!

Regards,
Chris

This post has been answered by John Snyders-Oracle on Jun 8 2021
Jump to Answer
Comments
Post Details
Added on Jun 8 2021
8 comments
1,723 views