OBI Query does Not Rewrite With Left Outer Join in From Clause (Doc ID 1102321.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

A query generated by Oracle OBI does not rewrite when it has a left outer join in the query in the FROM clause.  If the query is rephrased so that the left outer join is moved to a WITH statement, or if  an inner join is used, or a right outer join is used, then the query does rewrite.

These are the messages in the rewrite_table:

MV_NAME MESSAGE
-------------------------------------------------------------------
WC_SALE_MONTHLY_A QSM-01150: query did not rewrite
WC_SALE_MONTHLY_A QSM-01219: no suitable materialized view found
to rewrite this query
WC_SALE_MONTHLY_A QSM-01263: query rewrite not possible when
query references a dictionary table or view

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms