APP-FND-01206, Custom form 6i
Hi!
I have upgraded a custom form from FORMS 4.5 to FORMS 6i. When I try to make an insert from my form, I get the following application error: "app-fnd-01206 This record is already exits. You entered a duplicate value or sequence of values that must be unique for every record"
I have tried to debug my form and it seems like the errormessage is beeing displayed before the on-insert trigger is executed. That means it doesn't even try to make the insert.
The pre-insert trigger executes OK, that's where I set my standard who columns.
I do have two unique indexes on the table. I tried to drop these indexes, but I still got the same error.
I do have a sequence as well, but I have checked that the .nextval is a larger value than the max ID in the table.
I would be very grateful if anyone could help solving my problem.