How to Verify User and New password

·         =>Use the below query as apps user to verify if the password is changed

select fnd_web_sec.validate_login('<USERNAME>','<NEWPASWD>') from dual;

·         The output of this query if “Y” then password is changed, if “N” then there was a problem in password change

·         

Example:

SQL> select fnd_web_sec.validate_login('ABCDEF','xxxxxx') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('ABCDEF','xxxxxx')

-------------------------------------------------------------

Y