“Can you please reset my Oracle Apps Password in a testing environment? I tried changing from Edit->Preferences->Change Password, but it is disabled”
“Okay, sure. Let me reset the password for you”.
Navigate to System Administrator->Security->User-> Query the User to reset password. Opps, the password field itself is disabled. Strange, it wasn’t like that before.
What changed? Why is user password field disabled in Oracle Apps?
Technical mind swung in action. Let’s do it from backend using fnd_user_pkg.changepassword API.
DECLARE l_ret_status BOOLEAN; BEGIN l_ret_status := fnd_user_pkg.ChangePassword(username => 'DEMO_USER' ,newpassword => 'welcome123'); IF l_ret_status THEN dbms_output.put_line('Password changed successfully '); ELSE dbms_output.put_line('Error while changing password '|| fnd_message.get); END IF; EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Error while changing password ' || SQLERRM); END;
Above script did not work. It gave error something like ‘Password not managed by Oracle Apps’
Are you facing the same problem?
Read the below small article to resolve it.
Recently there are changes done in the production environment. SSO login is enabled using the Oracle Internet Directory, and DBAs have set profile Applications SSO Login Types to SSO.
Change the profile to Local for the respective user and that should make it enabled.
Applications SSO Login Types
If your site has implemented single sign-on with Oracle Internet Directory (OID), this profile option determines how users can log in to Oracle Applications.
- SSO – User passwords are maintained only in OID. Users must log in to Oracle Applications through single sign-on.
- Local – User passwords are maintained only in Oracle Application Object Library. Users must log in through the local Oracle Applications login page.
- Both – User passwords are maintained both in OID and in Oracle Application Object Library. Users can log in to Oracle Applications either through single sign-on or through the local Oracle Applications login page. A user’s single sign-on password can be different than that user’s Oracle Application Object Library password.