Dbvisit Replicate has powerful conflict resolution build built-in that allows for different resolution resolutions depending on the requirements of the business.
When a conflict occurs the whole replication is suspended until the conflict is resolved. This is to ensure transactional integrity.
...
Conflict detection - when there is a possibility of data divergence, a notification or alert is triggered. DBA sees conflict DBAs can be notifiied of the conflicting SQL
- Conflict resolution - when a conflict occurs, enough information about the conflict is shown so that the conflict can be resolved
- Conflict handling - set predefined rules to say what to do when a conflict occurs (includes setting PL/SQL business rules)
...