2 Replies Latest reply on May 15, 2015 11:09 AM by 2892158

    Sending Email to User based on USER PREFERENCES Language.


      The requirement is, a email should be sent to user based on USERENV('LANG') Looks simple but the complicated part is we need to pass values to the email at run time as follows:


      HI &User, --Here User should be passed.

      The site With Active Status are &Site_List.--Here Site_List is to be passed at run time.



      1.)DataBase Version is

      2.)I have tried  FND_MESSAGE so far i have created message with Three Languages ARABIC, FRENCH, ENGLISH based on USER Preferences language it has to pick email and send message body but i dont see any Function/Procedure to get USerPrefered languagefrom FND_MESSAGE API