Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX_UTIL.EDIT_USER API and change password issue

435162May 7 2007 — edited May 9 2007
Hi, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2007
Added on May 7 2007
4 comments
1,661 views