- OracleApps Epicenter - http://www.oracleappshub.com -

Its all about globalization (formerly internationalization) support in Oracle E-Business Suite

For company operating in multiple countries and have Single Global Instance, may have to understand the features of globalization (formerly internationalization) support in Oracle E-Business Suite. Things which is covered under internationalization are:

Oracle EBS & National Language Support(NLS)

NLS setting gived ability to run in a language other than English and have ability to use date, number, and currency formats specific to certain country or region

Sometimes referred to as Locale , in EBS sometime you heard NLS patches...these are special patches that provide language translations including user interface labels, menus, and some Oracle seeded setup data.

Oracle EBS and Unicode Support

Unicode is a universal character set which includes all major scripts of the world in a simple and consistent manner

  • Oracle database supports two Unicode character sets:
    • AL32UTF8: based on latest Unicode standard, currently 5.0
    • UTF8: on maintenance mode and supports Unicode 3.0 standard

Take a note, AL32UTF8 is the default Unicode database character set for Oracle EBusiness Suite installation in R12.1 when multiple languages are selected, where in 11i and R12 earlier had UTF8

Moreover ative character sets are still supported in EBS.

Oracle encourage to covert to AL32UTF8, as its support more characters and languages.

Fusion Apps will only support AL32UTF8 character set.

Those who is potentially looking for move to AL32UTF8 can explore Oracle Database Migration Assistant tool to provide an end-to-end
solution for migrating your databases from legacy encodings to Unicode

Oracle EBS and Multilingual Support (MLS)

That means Oracle E-Business Suite supports running multiple languages on the same instance simultaneously

Any number of supported languages (aka NLS patches) can be installed in a given instance

This Supports 34 languages covering 92 countries.

  • American English, Arabic, Brazilian Portuguese, Canadian ,French, Croatian, Czech, Danish, Dutch, French, Finnish,German, Greek , Hebrew, Hungarian, Italian, Indonesian,Japanese, Korean, Latin American Spanish, Lithuanian,Norwegian, Polish, Portuguese, Romanian, Russian, Simplified Chinese, Slovak, Slovenian, Spanish, Swedish, Traditional Chinese, Thai, Turkish, Ukrainian, and Vietnamese

Indonesian,Lithuanian,Ukrainian, Vietnamese are new in R12.1

you can enable Languages via License Manager Page.

When MLS is enabled you can notice the number of rows in Base Table(xxxx_B) and Translation Table (xxxx_TL)

Base table row contains language-independent attributes

That means for each row in base table, N rows exist in translation table corresponding to the N installed languages

One row for each installed language contains translated textual attributes

Regional Preferences that we call as Locale

These are typically consist of

International Calendar Support

R12.1.1 support Arabic Hijrah(The official calendar in Saudi Arabia with Arabic Hijrah month names ),English Hijrah(The official calendar in Saudi Arabia with English transliterated Hijrah month names). Users can choose their preferred calendar.

Hope this post helps to understand the latest internationalization suppport for Oracle EBS.