SSO password issue
wdbsvr.app file has getting incorrect password after the autoconfig.
Autoconfig use wdbsvr.app template file from $FND_TOP/admin/template and it use afwdbsvr.sh
Inside this file - is uses below code to get the password from the database and update the wdbsvr.app file under %s_iASconfig_home%/Apache/modplsql/cfg/wdbsvr.app
checked in database it is returning the below
SQL> declare
2 flag boolean := false;
3 flag1 boolean := false;
4 begin
5 flag1:=fnd_user_pkg.VALIDATELOGIN('PORTAL30_SSO','xxxxxx') ;
6 if (flag1) then
7 dbms_output.put_line ('PORTAL30_SSO User Exists and password is Valid');
8 else
9 dbms_output.put_line ('PORTAL30_SSO User Exists and password is Not Valid');