• Have you checked the linked server collation settings? Perhaps you could also manually collate to the collation defined on the Oracle database.

    It does seem like an issue related to collation since the problem only happens when you try to filter the result set.