This content has been marked as final. Show 3 replies
934803 wrote:This is really an Oracle issue making itself known through an Apex interfact.
We are using APEX 4.1. When we try to upload data to a table through upload wizard, even if the record is an update , it still shows "Insert" and then fails with "Primary Key violation" error. We have defined the correct Primary key at table and APEX interface.
Please advice what could be the issue ?
You correctly figured out that the PK was being duplicated and changed the PK. Check the USER/ALL_DBA_CONSTRAINTS table to make sure that the primary key was really changed. Then make sure that the new primary key isn't being duplicated by your data.