Loading

Monday, November 1, 2010

API to Update Oracle Applications Password (fnd_user_pkg.updateuser)

Below script can be used to update the Oracle apps password via API fnd_user_pkg.updateuser

 Script:

BEGIN
FND_USER_PKG.UPDATEUSER(x_user_name            => 'teamsearch'
                       ,x_owner                => 'SEED'
                       ,x_unencrypted_password => 'oracle@123'
                       ,x_password_date        => SYSDATE + 500);

END;

1 Responses to “API to Update Oracle Applications Password (fnd_user_pkg.updateuser)”

Anonymous said...
November 23, 2010 at 7:24 AM

Hi,
there is also dedicated function for password change:

apps.fnd_user_pkg.changepassword(username,
'newpassword');

regards,
marcin


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.