1 Reply Latest reply on Dec 8, 2019 8:36 AM by Maaz Khan

    user_preference in R12.2

    966638

      Hi,

      EBS - > R12.2.5

       

      I have one EBS user with email address ( user1 -> user1@mail.com).

       

      When I check table fnd_user_preferences against the user (user1), I can see entry only for module_name=PWDVALREUSE. There is no entry for PREFERENCE_NAME='MAILTYPE' and MODULE_NAME = 'WF'.

       

      1 - Please advise how to fix ?

      2 - Please advise what is "module_name=PWDVALREUSE"

       

       

      Thanks,

        • 1. Re: user_preference in R12.2
          Maaz Khan

          Hello,

           

           

          >>>1 - Please advise how to fix ?

          You can simply call api - FND_PREFERENCE package to change email-notification preferences. As in you case, we can call api as follows for user1
          exec FND_PREFERENCE.put('USER1','WF','MAILTYPE','MAILHTML');

          Ref - How To Change The E-mail Notification Preference En Masse For Multiple Users (Doc ID 417030.1)

           

           

          >>>2 - Please advise what is "module_name=PWDVALREUSE"
          If you observe PWDVALREUSE in this column, then it is an implication of setting profile - Signon Password No Reuse
          If this profile is set, it will not allow a user to reuse older passwords and older passwords are stored(encrypted format) in table fnd_user_preferences.

          Ref - How To Keep Track of FND User Password Changes (Doc ID 844520.1)

           

           

          Regards,

          Maaz