Validation "Column Is NOT Zero" Honored When Entering Values of 00, 000, 0000 etc etc.
(Doc ID 2106477.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Oracle Application Express (APEX) - Version 5.0.2 and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
An item has a validation of "Column Is NOT Zero" (or "Column Is NOT NULL or Zero). This works fine when entering a value of 0 in the field and trying to apply the changes, the following error is shown to the end user
"<COL> Must Have A Value & Cannot Be ZERO"
However, if the end user enters values of 00, 000, 0000. That is a series of zeros, then on applying the changes the value is accepted and thus managing to enter erroneous values of zero. Do note, the series of zeros are shown as a single zero when the page is reloaded.
Changes
None.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |