Login: ORA-01403: No Data Found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION

Login: ORA-01403: No Data Found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION

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

Cause:

Post Clone related issues with Oracle Applications Release 12.1.3

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.