To reset Oracle Apps user password through backend use the below script. Pass the username and password accordingly
DECLARE
x BOOLEAN;
BEGIN
x := fnd_user_pkg.Changepassword('username', 'password');
IF x THEN
dbms_output.Put_line('true');
COMMIT;
ELSE
dbms_output.Put_line('false');
END IF;
END;
x BOOLEAN;
BEGIN
x := fnd_user_pkg.Changepassword('username', 'password');
IF x THEN
dbms_output.Put_line('true');
COMMIT;
ELSE
dbms_output.Put_line('false');
END IF;
END;
Simply wish to say your article is as astonishing. The clarity in your post is simply great, and I could assume you are an expert on this subject. Same as your blog i found another one Oracle SOA .Actually I was looking for the same information on internet for Oracle SOA Suite and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.
ReplyDeleteGlad to know that it could be of any assistance to you. Cheers!
Delete