APEX 20.1 IG Columns not part of Source go null in DML

TMohamme

Hi, We are facing a peculiar behaviour in APEX 20.1 Interactive Grid DML process. I have a Grid with SQL: select eno,enmae,mgr from emp;

In the grid, I added an extra column DISPLAY_COLUMN whose source value is SQL Expression set as (ENO||' - '||ENAME) . This Column is not part of Grid Source.

When we update DISPLAY_COLUMN and click on Save (IG Save), :DISPLAY_COLUMN is going as null in Interactive Grid - Automatic Row Processing

Interestingly correct value of DISPLAY_COLUMN is being passed to Interactive Grid validations.

This issue is not seen in v19.1, but only in v20.1 (Oracle APEX)

Could this be a bug? Or Am I doing something wrong?

Thanks in advance

TMohamme

Filed Oracle Bug : 31718763 - INTERACTIVE GRID: VALUES OF "SQL EXPRESSION" COLUMNS ARE NOT VISIBLE IN "CUSTOM PL/SQL" DML PROCESS. Patch available. Patch # 30990551

TMohamme

Filed Oracle Bug : 31718763 - INTERACTIVE GRID: VALUES OF "SQL EXPRESSION" COLUMNS ARE NOT VISIBLE IN "CUSTOM PL/SQL" DML PROCESS. Patch available. Patch # 30990551