Through this script, we can validate any application user(apps user) or SYSADMIN password.If the given password is valid or not.

select fnd_web_sec.validate_login('SYSADMIN','Password') from dual;