OBI Apps externalize string for localizing the language as per obiee language settings

User_VJP67

Hi Friends,

we are using OBI Apps 11.1.1.8.1 version

We have pre built subject areas where language locale is working fine.

Used the LOCALE init block in OBIA PRE built RPD having -

SELECT 'VALUEOF(NQ_SESSION.WEBLANGUAGE)' FROM DUAL & got it in system variable LOCALE with default initializer 'fr'

We have added few new tables and new subject areas. 

now language locale is not working for new subject areas.

I have created initialization variable, externalise string etc still when on UI when I log in as French user by selecting the language option I still see the old english names.

I even queried for the locale variable on UI it too shows 'fr' i.e. french.

Is there any logic documentation for prebuilt initialization blocks that needs to know to implement the same logic for new subject areas

Please suggest guys...hopefully soon