We had a major upgrade to the current version of APEX (20.2) and are in the process of rewriting all of our applications. We use APEX to allow users to create data that isn't in our source system via an interactive report with form.
We have the easy reports with forms recreated - the ones that only update existing data
We struggle when we are allowing users to create new data - leveraging a sql sequencer to create the new PK (in the old system we used rowid - here we are using PK's) - we have made this work when we do a nexval in the computation of the pk but when we do this we lose the ability to delete data.
I am sure we are just missing a minor setting but we have been working on this for some time with no progress. We would prefer avoiding the use of a table trigger if possible.
Any advice?