Tuesday, August 2, 2011

Oracle APPS password change script

SET serveroutput ON

 DECLARE
 ret VARCHAR2(1);
 BEGIN
 ret := fnd_web_sec.CHANGE_PASSWORD('MORIN_AU','testing123');
 dbms_output.put_line(ret);
 END;
 /

SET serveroutput ON

 DECLARE
 ret VARCHAR2(1);
 BEGIN
 ret := fnd_web_sec.CHANGE_PASSWORD('XXXXXXXX@ORACLE.COM','testing$123');
 dbms_output.put_line(ret);
 END;

No comments:

Post a Comment