Perform a sqltrace on the query and view the output to see which table it is having trouble locating. Also, there is a bug in Metalink that looks real similar to this. Bug 1297277, which indicates to create a synonym instead of a view. Alos, it references init parameter star_transformation_enabled=true. But this is something you will have to do more research on, I've not used this parameter as of yet.