WebSessionManagerProc could not be resolved has been detected in FND_WEB_SEC.VALIDATE_LOGIN

We faced one clone issue in EBS R12. The login screen was blank and oacore log has the below error message
“javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE”

GUEST user validation was also failing.

SQL> SELECT fnd_web_sec.validate_login('GUEST','ORACLE') FROM dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
N

SQL> select fnd_message.get from dual;

GET
--------------------------------------------------------------------------------
Oracle error -29541: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc 
could not be resolved has been detected in FND_WEB_SEC.VALIDATE_LOGIN(u,p).

One of the DBA found that many JAVA CLASSES were invalid in the database.

 select count(*),object_type,owner,status from dba_objects where status='INVALID' group by object_type,owner,status;

  COUNT(*) OBJECT_TYPE         OWNER                          STATUS
---------- ------------------- ------------------------------ -------
        27 JAVA CLASS          SYS                            INVALID
       164 JAVA CLASS          APPS                           INVALID

We followed below steps to correct this situation

UPDATE ADLDJAVA.DRV 
1. Make a back up of the current driver file $AD_TOP/admin/driver/adldjava.drv 
2. Modify the contents of $AD_TOP/admin/driver/adldjava.drv to be as the list given above. 

REBUILD THE JAR/ZIP FILES 
1. Run Adadmin 
2. Select Generate Applications Files menu 
3. Select Generate product JAR files 

RELOAD THE JAR/ZIP FILES INTO THE DATABASE 
1. Run Adadmin 
2. Select Compile/Reload Applications Database Entities menu 
3. Select Reload JAR files to database 

RECOMPILE THE LOADED JAVA CLASSES 
1. Run Adadmin 
2. Select Compile/Reload Applications Database Entities menu 
3. Select Compile APPS schema

utlrp.sql  was executed next and autoconfig was executed on application node.

Application login page came up fine after that.

Reference:

How To Reload The APPS Java Class Objects In An Oracle Applications Environment 11i and R12 (Doc ID 468565.1)

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

WebSessionManagerProc could not be resolved has been detected in FND_WEB_SEC.VALIDATE_LOGIN

Related posts: