I'm not sure whether Oracle supports explicit value insertion into a timestamp column, but SQL Server doesn't allow this.

Try inserting a record into the Oracle table with explicit timestamp value.