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
- Run adadmin utility to generate reports or forms or messages. It will also show the base language and other installed languages on the application.
- 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
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
