API’s to Create User,Reset Password and Add Responsibility

I have created few queries using Oracle provided package:’FND_USER_PKG’. These queries might be very useful when you donot have the Oracle Apps front end access or you like to get in done through backend.

Using the below query, you can create a User in Oracle application.Just pass username, password and email id as parameters and it will create a user.

May a times we forgot the apps password. Then you can use the below query to resent the password just in few seconds.

Use the below query to add a responsibility to a user. The advantage here is that you donot require system administrator responsibility access to add a responsibility.

Related Posts:


    1. mein

      i get the same error while using fnd_user_pkg.createuser from a non-apps user(i mean if i run this through some other user id not a APPS userid) , how can we use it from any user id instead of just using it through APPS user.

  1. Daniel Longmore

    These are really helpful. Any ideas on how might I web enable the reset password function? Present to the user a web page similar to the login page where they could reset their own password.

  2. Dibyajyoti Koch

    Hi Daniel,

    This can be done by accessing the link ‘Forgot your password’ from the applications login page.

    Now how it works?

    a. A user access the apps login page.
    b. Select TIP Forgot your password? link
    c. A web page asks for the user name
    d. A new web page says:

    Your request for a new password is being processed.
    An email has been sent to the email address on file. Contact the system
    administrator if you do not receive your password within the next few hours

    e. A workflow process is started.
    f. Requester receives an workflow e-mail which subject is ‘Password reset requires approval.’
    g. The requester needs to respond the notification via e-mail.
    h. The workflow java mailer receives, reads and process the response.
    i. The User management workflow process changes the password to a automatically generated password and sends back an e-mail notification informing the new password.
    j. The users can now use the new password to access the EBS.
    k. The EBS requires the user to set his password again.

    How to implement the Forgot Password Reset Functionality?

    Please go through the steps mentioned in MOS Note:Reset Password Functionality FAQ [ID 399766.1]

    Hope It Helps…

  3. Asm


    I have used reset password package to change the user “operations” in EBS vision instance.Procedure successfully completed, but still able to login with old password.


Leave a Reply