I had the same issue. I created a view which pulled data from an Oracle DB via a linked server. My view worked fine.

When I referenced the view...