Friday, 2 August 2013

MLS and NLS Features In Oracle Apps



 National Language Support (NLS)


1. National Language Support (NLS) refers to the ability to run an Applications instance in any single supported language, including specific regional or territorial number and date formats.

2. Typically, in order to support a given language, only the customer-facing components of the Applications software (user interface, lookup tables, online documentation, and so on) are translated. 

3. Translations are delivered via NLS patches (more on that later).



 Multiple Language Support (MLS)

1. Multiple Language Support (MLS) refers to the ability to run multiple languages in the same Applications instance. 

2. MLS provides multiple language architecture, while NLS provides the individual language translations.

Enabling MLS Feature:-

Instructions from:

Oracle Applications, Maintenance Procedures, Release 12 
Adding and Maintaining NLS Languages

1. License Manager, active the language
2. adadmin, Maintain Multi-Lingual Tables 
(copies base language seed data)
3. Apply NLS patch 44400000 for the language 
(adds seed data translations)
4. Translation Synchronization Patch Utility and apply patch

5. Install NLS Help

Yes but now the fun begins

You must always apply the NLS Translation Patches for the patches you 
apply going forward, (this includes future upgrades).

This results in additional DBA work and increased down time windows

Your $APPL_TOP now includes many more code objects:
$AR_TOP/forms/<language>/ 
$AR_TOP/reports/<language>/
Deactivating a language is not supported. 
Even if you are not using them, once activated, you must maintain all languages that 
are active in an NLS system.
You have to now support your user base in non-English forms and 
reports.
Desktop procedures
Support calls
Customizations

No comments:

Post a Comment

Uploading PO Attachments from EBS to FTP Server

 create or replace PROCEDURE xx_upload_po_attachment(errbuff out varchar2, retcode out number)  IS CURSOR cur_new_attmt IS    select ponumbe...