APEX_UTIL.EDIT_USER API and change password issue
435162May 7 2007 — edited May 9 2007Hi, guys...
I understand that there were a lot of discussions of this functionality, and I have searched forum for answers, but I was not able to get clear picture on it…
We try to create a small application, which will allow customer care to manage main applications users, i.e. create user, delete user and edit user profile. We try to achieve this with APEX APIs. All APIs do work fine except one – APEX_UTIL.EDIT_USER. Actually it works too, but there is a problem – it does not reset password. It does not return error, it changes basic user’s info like id, last, first names etc… But the password remains unchanged. Long time ago I did ask about this API and Scott stated that there was a bug in fetch_fnd_user API related to processing password. (At those time we decided to put aside this idea and now it is again in our plans.) Now if I do not fill password’s boxes (leave them blank, which means that the password is not changing) APEX_UTIL.FETCH_USER and APEX_UTIL.EDIT_USER work fine. What makes it more strange – is that APEX_UTIL.ADD_USER and APEX_UTIL.CHANGE_CURRENT_USER_PW first one sets user’s password and second changes user’s password with no problems…
Any ideas? Help will be appreciated.
Thnks.
Mike