Oracle apps edit -> preferences -> change password field is disabled

0
46
views

“Can you please reset my Oracle Apps Password in a testing environment? I tried changing from Edit->Preferences->Change Password, but it is disabled”

edit preferences change password 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.

Read: – User Management using FND_USER_PKG API in Oracle Apps

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.

edit preferences change password 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.

Reference: https://docs.oracle.com/cd/B14099_19/integrate.1012/b12160/agprof.htm

Doc ID 434693.1

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here