20 September 2011

How to change the FND USER password with out Old password using PL/sql script


begin
fnd_user_pkg.changepassword('USERNAME', 'PASSWORD');
 end;
-- Input (Mandatory)
-- username: User Name
-- newpassword New Password
Examble :-
declare
 x  boolean;
     BEGIN
        x  :=    FND_USER_PKG.CHANGEPASSWORD ('MUTHU','shibanikutty');
     END;
 commit;

No comments: