My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2022

Applies to:

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


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.


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.