My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.