Skip to Main Content
Feature Request FR-3828
Product Area Page Components
Status CLOSED

1 Voters

Format Mask when App language not English

derik.tran Public · Jun 6 2024

Idea Summary
On a form, the data field for NON ENGLISH

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)

Use Case
References:

https://forums.oracle.com/ords/apexds/post/number-field-item-ig-number-column-bug-with-format-mask-whe-7146

 Link to Oracle bug information 

https://support.oracle.com/knowledge/Oracle%20Cloud/2994825_1.html

Preferred Solution (Optional)
We are currently on v22.2 and it's still happening even when it said the bug was fixed.

We reviewed this idea carefully and came to the conclusion that it does not constitute an appropriate APEX feature request.

Comments

Comments

  • vincent morneau Admin OP 1.1 years ago

    Hi @derik.tran ,

    This does not appear to be a feature request. I recommend following up on the forums thread. Thanks.

  • derik.tran OP 1.1 years ago

    I'm not sure I understand.  So there's a forums thread vs an ideas thread.  What's the difference in its purpose?  Can you provide the appropriate URL for that?

  • derik.tran OP 1.1 years ago

    Also, I did reference a link to the forums that I found from someone else.  They've done everything I would have already and there is still no solution.

    https://forums.oracle.com/ords/apexds/post/number-field-item-ig-number-column-bug-with-format-mask-whe-7146

  • vincent morneau Admin OP 1.1 years ago

    I was referring to the forums thread you linked. This would appear to be a bug. There seems to be confusion on wheter it is fixed or not. The APEX team uses the ideas app to discuss new feature concepts, and the forums is more appropriate to report, discuss and investigate bugs.