Skip to content

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)

 

[Post Views: 55]

Read Offline: PDF Download

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

Be First to Comment

Leave a Reply

Required fields are marked *