Re: Executing in different language that installed

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Executing-in-different-language-that-installed-tp8025p8028.html

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..