In Apex 21.1 Interactive Grid Not Null Column Validation Fails
(Doc ID 2824945.1)
Last updated on AUGUST 04, 2022
Applies to:Oracle Application Express (APEX) - Version 21.1.1 and later
Information in this document applies to any platform.
In Apex 21.1.3 when using IG(Editable) declared with two columns to be "required".When a new row is added to the grid, even if the cells are filled it says " must have a value" error message.
Issue remains same even when disabled the "required" flag and added a NOT NULL column validation rule also.
Test Case :
- Create IG region
- use SQL Query: select rowid, empno as "empno", ename from emp
- Enable Editing
- Make sure that "Value Required" is enabled for the "empno" column
- Save and run the page
Changes cannot be saved, since the "Value Required" validation for the lower case "empno" column always fails.
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