My Oracle Support Banner

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.

Symptoms

ACTUAL BEHAVIOR
------------------------------
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.

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.