From previous observations, I believe the error is raised if both source rows would actually change the value of the same target row. It's a little bit unsatisfactory and inconsistent (e.g. Change behaviour with an order by) http://orastory.wordpress.com/2011/10/13/merge-oddity/ >