OBIEE 11g: Difference In Query Generation For Same Report In Two Different OBIEE Environments (Exalytics Platform) (Doc ID 2182023.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

For OBIEE (on Exalytics Machine) version 11.1.1.7.150120 a user is finding different physical queries being generated for two similar environments.
The user was comparing the physical queries generated by nqserver in Development vs Production environments.
Both the environments were having:

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