• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Ebuisness Suite » Query to check languages installed in oracle apps

Query to check languages installed in oracle apps

July 6, 2022 by techgoeasy Leave a Comment

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

Filed Under: Oracle, Oracle Ebuisness Suite

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us