3 Replies Latest reply: Apr 2, 2013 11:05 PM by 880697 RSS

    How to disable all user accouts in oracle EBS R12

    880697
      Hi DBAs,

      How to disable all user accounts in EBS R12 except sysadmin, Guest & some other users using any standard concurrent or back end. Because tomorrow we are going to change all sequence number in our applications. So we want to restrict all users. Once that sequence changing activity has been done how to enable all users ? please help us in this activity.

      We already know Putting end date from front end.

      Thanks
      DBA
        • 1. Re: How to disable all user accouts in oracle EBS R12
          Srini Chavali-Oracle
          Use the FND_USER_PKG API code. This issue has been discussed many times in these forums - pl use the search feature

          Re: Disable Oracle apps user accounts

          https://forums.oracle.com/forums/search.jspa?threadID=&q=FND_USER_PKG&objID=c3&dateRange=all&userID=&numResults=15

          When Using FND_USER_PKG To Enable/Disable Users What Should Be The Value For X_OWNER? [ID 948191.1]
          How to End-Date/Delete an Applications User [ID 1064798.1]

          HTH
          Srini
          • 2. Re: How to disable all user accouts in oracle EBS R12
            Hussein Sawwan-Oracle
            Hemanth wrote:
            Hi DBAs,

            How to disable all user accounts in EBS R12 except sysadmin, Guest & some other users using any standard concurrent or back end. Because tomorrow we are going to change all sequence number in our applications. So we want to restrict all users. Once that sequence changing activity has been done how to enable all users ? please help us in this activity.

            We already know Putting end date from front end.

            Thanks
            DBA
            Please see these links.

            http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=FND_USER_PKG&c_owner=APPS&c_type=PACKAGE
            http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=FND_USER_PKG&c_owner=APPS&c_type=PACKAGE%20BODY

            https://forums.oracle.com/forums/search.jspa?threadID=&q=fnd_user_pkg.updateuser+AND+End+AND+Date&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

            Thanks,
            Hussein
            • 3. Re: How to disable all user accouts in oracle EBS R12
              880697
              Hi Hussein/Srini,

              Thanks for your Information.

              Thanks
              DBA