My Oracle Support Banner

OBIEE 12c - case sensitivity of USER session variable value (Doc ID 2673305.1)

Last updated on MAY 27, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 to 12.2.1.4.200414 [Release 12g]
Information in this document applies to any platform.

Symptoms


Upon log in to analytics, USER session variable is populated with lower characters in OBIEE 12c in SSO or Non SSO setup.

The reports are failing as there is a where clause using VALUEOF(NQ_SESSION.USER) compared with database column with upper values.

There are over 1000 reports which are failing.

The reports worked ok in OBIEE 11g where Authentication and Authorization session initialization blocks configured for Security.

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!


In this Document
Symptoms
Cause
Solution


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