Technology Stack - EBS (MOSC)

MOSC Banner

SSO password issue

edited Aug 20, 2021 11:25AM in Technology Stack - EBS (MOSC) 1 commentAnswered
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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center