Script to change the oracle apps front end password.

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;

/