I have an interactive grid that is based on a table and all the columns are being queried explicitly. Whenever I try to update a column value and save, I see this error. The not null column is rec_id which is also drawn from a sequence and a before insert trigger exists to default the value based on a sequence. There are posts about this error, but my primary key column is made query only, still I see the error. What could be other possibilities? We are on 18.1.
Ajax call returned server error ORA-20987: APEX - Process 'Save Interactive Grid Data' raised 'ORA-01733: virtual column not allowed here' while executing a DML command. This error can occur if a column is based on an aggregation or SQL expression. Set column attribute 'Query Only' to Yes to exclude the column from the INSERT and UPDATE statement.