I think I know what cause it. It looks like that the Oracle OLE DB Provider doesn’t support nested transaction. Try this:

BEGIN TRAN T1

INSERT Table1 SELECT 'xxxx'

BEGIN DISTRIBUTED TRAN...