Thursday, March 2, 2017

Reset Oracle Application User Password through API

DECLARE
flag_value BOOLEAN;
BEGIN
flag_value := fnd_user_pkg.changepassword(username=> 'RJAYANTH',newpassword => 'welcome1');
IF flag_value
THEN
DBMS_OUTPUT.PUT_LINE('The password reset successfully');
ELSE
DBMS_OUTPUT.PUT_LINE('The password reset has failed');
END IF;
END;
/
COMMIT;


No comments:

Post a Comment

How to Compile Forms , Reports & Custom.pll in R12.2

How to Compile Custom.pll   cd $AU_TOP/resource  cp CUSTOM.plx CUSTOM.plx_bkup  cp CUSTOM.pll CUSTOM.pll_bkup  frmcmp_batch module=CUSTOM.pl...