Hello
I'm using oracle apex 22.1 over a 21c DB.
I'm creating a form that allow the user to add some lines on a quote. The lines can be for fixed charges, which are based on a list of predefined values located on a table, or variable changes that can be customized as needed. Each line will have a unique line ID which is created just to define the sequence of the lines and it's not the PK.
To provide a clean look and feel, I set up three regions, one for the line number, one for the Fixed charges, and one for the Variable charges.
When the user select the type of line which will be created the form show to corresponding region and hide the other.
The fixed charges and variable charges use some specific fields of the table, I mean, when a fixed charge is crated, some fields will be set to null, and when a variable charge is created some other will be set to null.
One specific field used to store the RATE for variable charges is hidden, and only is assigned based on some calculations in a process before the form submit.
Somehow my form is refusing to store the fixed charges reporting that the "Rate must be a valid number". Nowhere in my form is any validation linked to the rate field, and assuming that the RATE field is hidden, is pointless to have such validation.
Trying some work around I make visible the RATE field and input a numeric value, but the validation keep preventing the insert.
Anyone have found a situations like this, and know how to fix it?
Appreciate any comment
Regards
W