FND_SESSION_MANAGEMENT.CHECK_SESSION When Logging On

Posted by Vasudev Seeram on September 26, 2013 Leave a comment (0) Go to comments

Problem: After disabling maintenance mode and logging on, the following error appears:

<PRE>Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: 
at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session 
is no longer valid. </PRE>
Servlet error: An exception occurred. The current application deployment 
descriptors do not allow for including it in this response. Please consult the 
application log for details.

Solution:

1. Please execute the following scripts from $FND_TOP/patch/115/sql
SQL> @AFICXSMS.pls
SQL> @AFICXSMB.pls
Please ensure that the package FND_SESSION_MANAGEMENT is valid and confirm the version again.

2. Bounce the server.

Reference: Login Page Throws Error 1403: Java.Sql.Sqlexception: Ora-01403: No Data Found Ora-06512: At Line 1 H (Doc ID 1336030.1)