hi
iam using us english in my apps.
i want to know how to insert german language descriptions
in tl table provided by oracle .

thanks in advance .

Are you looking for information about how to install MLS for the apps?  I’m currently working on a project that supports 6 languages for our installation: Czech, German, Italian, Latin American Spanish, English, and Simplified Chinese.  There are pro’s and con’s for supporting multiple languages.  You should also distinguish between applications language support (eg. the language(s) presented in the user interface) and data language support (eg. the language(s) used to input and store data in the database.

Give us a better idea on what it is you are trying to accomplish, and I’m sure we can provide some guidance.

Regards,

Michael Siebert

hemanth - 02 August 2005 04:26 PM

hi
iam using us english in my apps.
i want to know how to insert german language descriptions
in tl table provided by oracle .

ex: i want to insert the item description in german in the table

mtl_item_categories_tl






thanks in advance .

If US English is the only language installed, then creating a record for a german translation won’t provide you with the desired result.  MLS support in 11i has changed over the way it was handled in prior releases.  As I mentioned earlier, we are supporting 6 languages on my current project installation.  As such, we have at least 6 records in the _tl tables (one for each language).  These tables are maintained using the ‘Maintain Multilingual Tables’ functionality of adadmin.

Review MetaLink Note 211708.1 which provides an explanation of how NLS and MLS are handled in 11i.

What version of the apps are you using?  Our installation (11.5.10.2) doesn’t have ‘mtl_item_categories_tl’.