OBIEE 12c : Few Reports Migrated From OBIEE 11g throw error: "Comparison is being carried out between non-compatible types DATE and VARCHAR" (Doc ID 2190067.1)

Last updated on JULY 18, 2017

Applies to:

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

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE): 12.2.1.0.0 version and later, Analytics

After upgrade from OBIEE 11g to 12.2.1.x.x, few reports throw following Error  

Error:
"comparison is being carried out between non-compatible types DATE and VARCHAR"

Changes

 Upgrade from 11g to 12c

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