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 -

Create a new init block.
In the Init block, use the following SQL to set the 'USERLOCALE' variable,

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

According to the results, the value of NQ_SESSION.USERLOCALE should be set as 'en-in'.
In Analytics, go to the following: Analytics --> My account --> Preferences and check the following option - Locale (location).

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.