My Oracle Support Banner

Consistency Check Error 38118: Join type in table source of logical table does not match the join (Doc ID 2532812.1)

Last updated on AUGUST 16, 2019

Applies to:

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


OBIEE is upgraded from to

On the upgraded rpd, Consistency check is reporting Error number 38118 on some LTS objects. This wasn't an issue in

For example:
Join type between OBJECT1 and OBJECT2 below is Left Outer 

Post upgrade, the Consistency Check (File-> Check Global Consistency) reports following error:
Error number 38118 Join type in table source OBJECT1 of logical table OBJECT2 does not match the join.

This join type changes from Left Outer to Inner when Auto Fix (File -> Check Global Consistency -> Auto-Fix) is run. 
See below, post upgrade:

It causes the analysis/dashboards to show incorrect and unexpected results. 





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.