| ERROR | no query rewrite on remote objects unless integrity mode is set to stale_tolerated |
| CAUSE | Query rewrites integrity mode should be set to stale_tolerated for query rewrite to occur on queries with remote objects |
| ACTION | Set the session parameter, QUERY_REWRITE_INTEGRITY to stale_tolerated |