Here is a sample anonymous PL/SQL block which will reset the Oracle Apps front end password for a given user from back end.
DECLARE
flag_value BOOLEAN;
BEGIN
flag_value :=
fnd_user_pkg.changepassword(username=> 'SXMARGAM'
,newpassword => 'welcome1');
IF flag_value
THEN
DBMS_OUTPU.PUT_LINE('The password reset successfully');
ELSE
DBMS_OUTPUT.PUT_LINE('The password reset has failed');
END IF;
END;
/
COMMIT;
kırklareli
ReplyDeletetekirdağ
giresun
adıyaman
manisa
EMXB