patched failing tests and migrated transripts table to oracle