I am working with Oracle APEX and using an Interactive Grid with Flashback functionality enabled. One of the columns in my grid, named BAKIYE_QTY, is a query-only column (it is calculated using a SQL query and does not exist in the underlying table).
When I attempt to use Flashback, I encounter the following issue:
The Flashback operation fails with an “Insufficient Privileges” error.
If I remove the queryonly column from the grid, the Flashback works fine and the record is returned as expected.
I believe this issue occurs because the specified column is a computed column and not part of the underlying table, causing the Flashback to fail.
How can I exclude certain query-only columns from being considered in the Flashback functionality of an Interactive Grid in Oracle APEX?
Is there a way to conditionally include or exclude such columns only during Flashback operations?
Removing the column completely from the grid (this resolves the issue but is not ideal since the column is needed in the UI).
Searched for a setting in APEX to exclude specific columns from Flashback but couldn’t find one.
Sinan ÖLKER is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.