Executing in different language that installed

[Linda]

Hi Erman!
How are you ? :) Time flyes fast..
Hope not to late wish all the best in 2020 :)

SImple Question:
In EBS 2 languages: Base - US, Installed - RU
How I run the custom program(package) from backend(sqlplus)  the same way as from RU interface in front end ?
Is it enough  in sqlplus to do :execute immediate 'alter session set NLS_LANGUAGE = Russian';
to simulat the same from front page ?

Ofoucre org, resp initializing as well.
Br,L.

[ErmanArslansOracleBlog]

Hi Linda,

Thanks, fine but busy :)
Wish you the same :)

If you want to work with the _TL tables and VL views, then yes, correct. (using fnd_global.set_nls_context(p_nls_language => 'RUSSIAN' may be a better idea)

But if you need to have an apps context set, then you have to initialize it using fnd_global.apps_initialize.
According to the code and environment, you may even need to use mo_global package..
You may event set client info using dbms_application_info (if using multi org and your code is accessing multi org partitioned objects..

I guess you get the idea :)

Also check -> http://anilpassi.com/apps/demo/misc/For_Blog_Debugging_Running_the_SQL.pps
This blog post give a detailed info about what to set..