3 Replies Latest reply on Nov 19, 2019 2:21 PM by Beauty_and_dBest

    How to check what Language is set in our EBS database?

    Beauty_and_dBest

      EBS 12.1.3

      OL6

       

       

      Hi ALL,

       

      We have issue in retrieving data in our table language code.

      The support is asking below:

       

      Since NLS_LANGUAGE is set to 'ENGLISH', userenv('LANG') is
      returning 'GB'.In MTL_SYSTEM_ITEMS_TL table (as per out of query B) there are
      no records for language code 'GB' hence _VL is not returning any record.

      Kindly ask the customer's DBA to set NLS_LANGUAGE to 'AMERICAN for
      userenv('LANG') to return 'US' and then query on _VL will fetch the data
      correctly.

       

       

       

      How do I set NLS_LANGUAGE for our EBS instance?

       

      Please help...

       

      Kind regards,

      jc