Forum Stats

  • 3,740,448 Users
  • 2,248,256 Discussions
  • 7,861,252 Comments

Discussions

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

TMohamme
TMohamme Member Posts: 46 Green Ribbon
edited Aug 18, 2020 9:31PM in APEX Discussions

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

Best Answer

  • TMohamme
    TMohamme Member Posts: 46 Green Ribbon
    edited Aug 18, 2020 9:31PM Accepted Answer

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

Answers

  • TMohamme
    TMohamme Member Posts: 46 Green Ribbon
    edited Aug 18, 2020 9:31PM Accepted Answer

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

Sign In or Register to comment.