My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


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:

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.