Script to change the
oracle apps front end password.
set serveroutput on;
DECLARE
   v_pwd                         VARCHAR2 (40);
BEGIN
   v_pwd :=
fnd_web_sec.change_password (p_user =>         'SANGU'
                                                                       ,p_new_pwd =>      'welcome123'
                                                                       );
  
DBMS_OUTPUT.put_line ('pwd ' || v_pwd);
   IF (v_pwd =
'N') THEN
     
DBMS_OUTPUT.put_line ('New Password Change' || ': ' || fnd_message.get
                                                                            
());
   END IF;
END;
/
