I have an interactive grid for a table which is enabled to edit and the table has 3 columns, one of the columns is ID column which is primary key where I have used trigger to populate the sequences, in this table I have recently added 2 new columns in the IG source - SQL query, after this addition I can run the page and can see the newly added columns but when I click Add a row in IG and try to insert a record into the table the primary key column is throwing error as cannot insert null into ID column, even though my trigger is present.
Here my question is before this new addition of column the IG was working fine and allowing me to insert a row in the table but after the change it is not working as expected, what could be the reason and what are the work around I have to follow to resolve this error.
Note: I am using Oracle Apex 23.2.4 version.