Thursday, January 30, 2014

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.

Issue:

Error after login page while executing operations/welcome

<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
 

NOTE:

Please ensure that the package FND_SESSION_MANAGEMENT is valid and confirm the version again.

2. Bounce the server.

3. Retest the issue.


4. Migrate the solution to production instance.

1 comment:

  1. Done the steps provided by you as in metalink site but still the issue persists

    ReplyDelete