Update FND User Password

Following is a script to update FND User password programatically from the database in Oracle:

DECLARE
   l_updpwd   BOOLEAN;
BEGIN
   l_updpwd := fnd_user_pkg.changepassword ('SVISHNUB', 'ebspro');

   IF l_updpwd
   THEN
      COMMIT;
      DBMS_OUTPUT.put_line ('success');
   ELSE
      DBMS_OUTPUT.put_line ('failed');
   END IF;
END;