EBS 12.2 NLS Language Installed and ADOP NLS Patch Commands

NLS Installed Languages in E-Business Suite

 

Oracle's National Language Support (NLS) enables access to retrieve the data functionalities in native languages. Oracle allows installing the native languages in all versions of EBS applications. NLS installed languages in EBS 12.2 ensures the functionality in native languages.

 

Query to know NLS Installed Languages:

set lines 180
set pages 50
col LANGUAGE_CODE for a15
col NLS_LANGUAGE for a20
col ISO_LANGUAGE for a15
col INSTALLED_FLAG for a15
SELECT LANGUAGE_CODE, NLS_LANGUAGE, ISO_LANGUAGE, INSTALLED_FLAG
FROM APPS.FND_LANGUAGES
WHERE INSTALLED_FLAG IN ('B','I');

 

Sample Output:

 

LANGUAGE_CODE                NLS_LANGUAGE                      ISO_LANGUAGE             INSTALLED_FLAG
---------------------------       --------------- ---------            -----------------------     -------- ----------------
US                                         AMERICAN                                EN                                  B
CS                                         CZECH                                      CS                                  I
D                                           GERMAN                                   DE                                  I
E                                           SPANISH                                   ES                                  I
F                                           FRENCH                                    FR                                   I
 

Here, US American is BASE language.

 

ADOP Query to apply NLS Patches

 

EBS 12.2 uses adop utility to apply patches. Similarly, in EBS 12.1 or 11i adpatch utility is used.

·        To apply NLS patches first Base Language US American English patch should be applied.

·        Once US Language patch applied successfully, we need to apply all present NLS

·        To know which all NLS languages are installed using the above query.

 

Prepare the adop command to apply NLS patches

 

Assume we have to apply patch 3936249. Apply US Language patch first.

 

          Command to apply US language patch

          adop phase=apply patches=3936249 (when applying patches in adop mode)

          adop phase=apply patches=3936249 hotpatch=yes (when applying patches in hotpatch mode)

                   

          Command to apply NLS patches

          adop phase=apply patches=3936249_CS:u3936249.drv,3936249_D:u3936249.drv,3936249_E:u3936249.drv,3936249_F:u3936249.drv (when applying the patches in adop mode)

          adop phase=apply patches=3936249_CS:u3936249.drv,3936249_D:u3936249.drv,3936249_E:u3936249.drv,3936249_F:u3936249.drv hotpatch=yes  (hotpatch mode)

 

 

 

Conclusion:

 

Oracle allows us to work on native languages. In order to activate native languages, we must apply NLS languages. Additionally, we must apply all patches with NLS patches to keep the functionality works properly. NLS Installed Languages in E-Business Suite enables various advantages to users in so many ways.