-= Apex 20.1 =-
We've an Interactive Grid report that is based on two tables, as shown below. As you can see that the ROWID is coming from the DD table, when we run the following SQL from SQL Developer we get the ROWIDs from the DD table, as expected, however, from IG the ROWIDs are being fetched from DS table. That is causing ORA-01410 errors when we are updating or deleting any records. Both DD and DS are REGULAR TABLES.
select dd.rowid, dd.emp_id, ds.location, ds.team
, dd.MON_STRT, dd.MON_END, dd.TUE_STRT, dd.TUE_END, dd.WED_STRT, dd.WED_END, dd.THU_STRT, dd.THU_END
, dd.FRI_STRT, dd.FRI_END, dd.SAT_STRT, dd.SAT_END, dd.SUN_STRT, dd.SUN_END
from dd, ds
where dd.emp_id = ds.emp_id;
From SQL Developer:
From IG:
Any idea why IG is behaving in such a bizarre way?