Not matching the SYS_CONTEXT('USERENV', 'LANG') with oracle fod schema data
909329Jan 17 2012 — edited May 8 2012I have imported the fod schema into oracle XE. I observed that the data available for following languages:
SQL> select distinct language from category_translations;
LANGUAGE
------------------------------
EN
EL
FR
DE
JA
But, when I check the value for the LANG in oracle XE, it is returning as 'US'.
SQL> select SYS_CONTEXT('USERENV','LANG') FROM DUAL;
SYS_CONTEXT('USERENV','LANG')
----------------------------------------------------
US
Becasue of this, I am not getting data when I run VOs from JDeveloper. Even I am not able to see data from FOD schema views.
Please suggest what changes I need to do for getting data.