Filter View Shows Date In MM/DD/YYYY Format Which Creates Confusion For English-GB Users

(Doc ID 1902991.1)

Last updated on AUGUST 26, 2014

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


OBIEE 11g,, for instance.

When the browser is set to English-United Kingdom (en-gb), it is not being reflected by OBIEE upon first login to OBIEE by new users.

In OBIEE, for the user, My Account-Preferences, the

'Locale (location)' is set to English-United States (en-en)

even though the language in the browser is set to English-United Kingdom (en-gb).

When the language is set to German and French for example, it works just fine and even English-United States works.  However, English-United Kingdom (en-gb) does not and gets set to English-United States (en-en).

1. Created a new user in myrealm in the WLS Console, a default WLS user, TestUser1.
-Add this user to the BIConsumer Role in EM.
-Then set the IE Browser to have the Language German.
-Closed out of IE and opened it again.
-Logged into Analytics and see that the login screen is set to Deutsch.
-Once logged in go to my account and see it is set to German for this first time login for TestUser1.
-Date shows as DD.MM.YYYY

2. Repeat step 1 steps, but this time for English-United Kingdom (en-gb) for TestUser2.
-For TestUser2 the login screen shows English, which is the only English choice in the drop down on the Analytics login screen.
-Continue to log, but see the My Account language shows English United States (en-en).
-Date shows as MM/DD/YYYY

3. Test a 3rd time for TestUser3 - French.
-Login set to Francais.
-My Account - set to French.
-Date shows as DD/MM/YYYY.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms