I have a validation called “Comm limit” on an Interactive Grid with the following setup:
:COMM is null or to_number(:COMM) < 1.5 * to_number(:SAL)
Error message:
Commission must be less than 1.5 times the Salary.
Associated Column: SAL
When I set Associated Column = COMM
Everything works correctly.
If I enter a large number for Commission (for example 455555),
I get the validation error message.
When I change Commission to a smaller value (for example 1),
the error message disappears, and the row can be saved successfully.
When I set Associated Column = SAL
(or any other column different from the one used in the validation expression)
The validation does not work correctly.
If I enter a large Commission value (e.g. 455555),
the validation error appears next to the Salary column as expected.
But when I correct the Commission value to a smaller valid number,
the error message does not disappear,
and the row still cannot be saved.
Expected Behavior
The validation error should be cleared, and the row should be saved
once the Commission value satisfies the validation expression again,
even if the Associated Column is different from the column used in the expression.
Environment
- Oracle APEX 24.x
- Interactive Grid region
- Validation type: SQL Expression
- Demo