Full Outer Joins in Oracle
When using an Oracle RDBMS data source prior to version 9.2.02, full outer joins return incorrect data results. To avoid this problem, Cognos 8 processes these as local operations.
As a result of this processing, you must set the query processing to limitedLocal for any projects that expect explicit or implicit outer joins.
