My Oracle Support Banner

OBIEE 12c: Unable to Set System Session Variable "NQ_SESSION.USERLOCALE" via Initialization Block (Doc ID 2259283.1)

Last updated on FEBRUARY 28, 2020

Applies to:

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

Symptoms

On Oracle Business Intelligence Enterprise Edition 12.2.1.x version,

When trying to set the system session variable - "NQ_SESSION.USERLOCALE" via init block,  unable to do it. 

Steps for setting"NQ_SESSION.USERLOCALE" variable:

A sample scenario is given here - 

SQL> select decode ('VALUEOF(NQ_SESSION.WEBLANGUAGE)', 'en', 'en-in', 'ar','ar-dz','en-gb') from dual;
Expected Results:

Locale (location) should display - 'English - India'.

Actual Results:
    1. Locale (location) still shows - 'English - United States' instead of 'English - India'.
    2. Open RPD in 'Online' mode, go to Manage ---> Identity --> Variable --> Session Manager and check the variable: USERLOCALE, it  shows 'en' for WebLogic user. Refer the attached screenshot.

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
 Steps for setting"NQ_SESSION.USERLOCALE" variable:
 Expected Results:
 Actual Results:
Cause
Solution
References


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