Unable to generate forwarding URL. Exception: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE

Unable to generate forwarding URL. Exception: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE 

Now we came to know that there is some problem with Guest user. So validate the Guest user 

Work Around Done.

SQL> select FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) from dual;
FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’)
——————————————————————————–
N

The above Query should show Y but it shows N. So we need to check for the reasonSQL> select fnd_message.get from dual;
GET
——————————————————————————–
Oracle error -449: ORA-00449: background process ‘MMON’ unexpectedly terminated
with error 448 has been detected in FND_WEB_SEC.VALIDATE_LOGIN(u,p).

So the above error states that there was Abnormal termination happened by MMON. 

Solution:
Restart DB and Listener and apps and check for the Validation of Guest user

SQL> select FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) from dual;

FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’)
——————————————————————————–
Y