Home » Oracle » Oracle Ebuisness Suite » Query to check languages installed in oracle apps

Query to check languages installed in oracle apps

We can have different languages installed in Oracle apps. Here is the Query to check languages installed in oracle apps

select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in ('B', 'I');

The Installed_Flag has 3 values

I- Installed
B- Base
D- Disabled

Example

sqlplus apps/<apps pass>
select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in ('B', 'I');
LANG
_____
US
D
FR

Important Points

  • The above query is valid for all versions of Oracle apps 11i, R12, R12.1. R12.2
  • Depending on the number of Languages, your APPL_TOP and Database size will grow also.
  • you will have to apply the NLS version of these patches also when applying any new patches

You can also find the Languages installed in the below ways

  1. Run adadmin utility to generate reports or forms or messages. It will also show the base language and other installed languages on the application.
  2. Log in to Oracle applications
    Go to System Administrator responsibility > Install > Languages

You can find more about MLS (Multi-language installation) in Oracle Apps at the below note

MLS Installation in 11i/R12

The above note clearly explained how to add new languages and how this multi-language installation works in Oracle apps. I hope you like this article on Query to check languages installed in oracle apps. Please do provide feedback to Improve

Related Articles
Adpatch: Learn about Oracle patching: Adpatch, types of patches, how to apply in R12, sequences of steps performed by it, how to download patch
ADMRGPCH: Learn about AD Utilities(adadmin, adrelink,adident, ADMRGPCH), How to run them, and How to maintain application files using adadmin
Profile options in Oracle Apps : Check out this page for a deep dive on Profile options in Oracle Apps,How to change it using FND_PROFILE API ,direct query
Important Oracle Forms Architecture Features in R12
Oracle Concurrent Manager and Types: How an E-Business Suite Concurrent Manager Process Works, Oracle Concurrent Manager, What is internal monitor, What is service manager and troubleshooting
How to run Autoconfig in oracle apps R12 : Check out this post for an in-depth discussion on Autoconfig in oracle apps R12,How autoconfig works in R12, logfile location for autoconfig

See also  how to find the Oracle database version

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top