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 126.96.36.199.0 to 188.8.131.52.200414 [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