Friday, December 26, 2014

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;

/