I tried to Insert/Update to Oracle table in DM but it returned Unique Constraint error even though I selected 'Update the existing record' for If the record exists attribute in target load options. Any suggestion welcomed.

Case closed.
Recreated synonym with unique key resolved the issue.

Thanks.