| gl_interface in R12 - translated values? [message #529196] |
Sat, 29 October 2011 11:41  |
 |
asmirnov9
Messages: 8
Registered: October 2011
|
Junior Member |
|
|
Dear,
I am working on some interface using such tables as
gl_interface_control and gl_interface in a multi-language environment.
My question - CAN I use hard coded string in queries like
AND user_je_source_name = 'Receivables'
or I should check the translation table as
select user_je_source_name
into v_source_name
from gl_je_sources_tl
where language = userenv('LANG')
and je_source_name = 'Receivables';
and use v_source_name in my query?
I did ran a test - I changed the language preference to Grman through self service preferences and ran the AR to GL Transfer interface but the entries in gl_inetrface are still in English? This is R12.1.3
Please let me know
Thank you for your time.
Anatoliy
|
|
|
|
|
|
|
|
|
|
| Re: gl_interface in R12 - translated values? [message #529219 is a reply to message #529218] |
Sat, 29 October 2011 15:49  |
|
asmirnov9
Messages: 8
Registered: October 2011
|
Junior Member |
|
|
OK, Vamsi, I think I got it -
"Prior to Release 12, it was needed that the Journal Import should be run in the same language as the language, which was used to transfer data to GL_INTERFACE. Though this is not much relevant now (the transfer and journal import are triggered together); still Journal Import can be made independent of the language. This can be achieved by running journal import using the Source and Category Key. Generally the columns user_je_source_name and user_je_category_name in gl_interface, correspond to the columns GL_JE_SOURCES.user_je_source_name and GL_JE_CATEGORIES.user_je_category_name respectively. These values change for the different language and thus making journal import language-dependent. However while defining the sources (General Ledger Responsibility : Setup -> Journal -> Source), if the option "Import Using Key" is selected, then import refers to GL_JE_SOURCES.je_source_key and GL_JE_CATEGORIES.je_category_key. These being the Key values are common across languages and hence journal import becomes language independent."
Thanks much for poiting this out to me, was helpful.
Best Regards
Anatoliy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
