Oracle APEX 24.1.6 | Oracle DB 19c
I have an interactive grid with a nullable field. When I add a row to the IG, I have no problems whether there is a value in this nullable field or not. However, when I go to update an existing row, and then accidentally tab or click into the nullable field, it triggers a validation error “'Column A' must be a valid number”.
As mentioned, the column is nullable. On the APEX side, “Value Required” is set to False. If I'm careful to make my update but not select into this nullable field, I do not get the validation error. The column does have a mask, and is populated from an LOV, but in this case it is just blank.
Again, the validation error triggers simply by selecting the particular column / cell when updating a row. I am not adding anything to it (not even spaces), it is nullable, and only when updating a record (not when adding one). I've been scouring the properties for the column and IG, but not sure what the issue is.
Changed ‘Item Count’ from 1 to 2, then hit ‘Tab’ twice, validation error on ‘Foot Amount’:
Thanks for any ideas and insight.
Jared