using APEX 4.2.1 on a form for insert/edit, when inserting using sequence to populate the primary key no matter where I put the process to get the nextval, which I can see is the correct value, getting the ORA-00001. When creating the form page chose the option primary key set by existing sequence. I also tried disabling the template process: Process Row of ... and created my own custom button and insert process and continue to get the error. Is this an APEX bug if so is there a work around. The only reference I've seen to this in this forum is to use a trigger on the table, I can try that but don't understand why putting the get nextval in the page does not work correctly.
Any ideas? thanks
Therese Salles