wisdomforce DatabaseSync has a feature for transactional audit when source is Oracle and destination could be SQL Server. The destination table can have a columns with previous data and new value along with transaction date and all other details about this transaction
oracle "change data capture" for auditing.  http://www.wisdomforce.com/products-DatabaseSync.html
It is a log base CDC replication