What version of OBIEE? Have you checked your log files for the exact SQL generated by the BI Server? Does the SQL run when you run it directly on the DB ie in SQL Developer/ TOAD/ SQL*Plus etc?
There error indicates that it is not exactly an OBIEE issue but an issue propagated from the Oracle data source hence the ORA-01445 error
+1 to Joel. That's a pure database issue.
What are you calling from OBIEE? A view that you imported as an object? A manually written opaque view that you wrote in the physical layer? A view that itself if built upon views?