@Obito If it is not possible to put coalesce, I would recommend you to create an on before script and query the records that matches the condition in the Business Rule and set ignore=true if there is a record that matches, this way the attempt to add the record to the target table will be stopped.
Please mark the appropriate response as correct answer and helpful.
Thanks!!
