17 September, 2015

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

No comments:

Post a Comment

OEM Agent Installation

./agentDeploy.sh AGENT_BASE_DIR=/u001/oracle/product/agent13c OMS_HOST=oem-dev.xxx.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=*****...