Unique Constraint Violation Error Even when no data exists
I am trying to insert into target table from staging table. The mapping consists of two lookups to get the foreign keys in the target table, and the target also has a primary key. This target had data in there that I deleted making it empty and now when I try to execute this mapping, I get the ORA-00001 :: unique constraint (PATHWAY.SYS_C0015911) violated error. This SYS_0015911 is the primary key key constraint on the target. What is going here??