oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int)(userId=6,sessionMode='null','B05B3112A9DFB0DEE040A8C014004A1B24567150843604980614305290700427'); REASON = java.sql.SQLException: ORA-04027: self-deadlock during automatic validation for object APPS.FND_CRYPTO ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 353 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 455 ORA-06512: at line 1 ; ERRNO = 4027; (Could not lookup message because there is no database connection)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by user11157039, 1 year ago
automatic validation for object APPS.FND_CRYPTO ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 353 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 455 ORA-06512: at line 1 ; ERRNO = 4027; (Could not lookup message because there is no database connection)
via Oracle Community by 531886, 1 year ago
-06512: at "APPS.FND_SESSION_MANAGEMENT", line 455 ORA-06512: at line 1 ; ERRNO = 4068; (Could not lookup message because there is no database connection)
via Oracle Community by 804738, 1 year ago
Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int, String)(userid=6','A26198979CC1FE7BE040A8C0E714126E19682271241064037327178121309578'); REASON = java.sql.SQLException: ORA-01653: unable to extend table
via Oracle Community by Soni, 5 months ago
Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int, String)(userid=6','4B762B847F88823DE040007F0100046C21176437061243239841321770433090'); REASON = java.sql.SQLException: ORA-20001: Oracle error -1116: ORA-01116
via Oracle Community by SG2, 1 year ago
Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int, String)(userid=6','63AE07C54D984076E040A8C0397C7B9F75597571027707257642267078847225'); REASON = java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001
via Oracle Community by 756829, 1 year ago
Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int, String)(userid=6','9C43948337702996E04400144F80B8A410120525916069750102902718816222'); REASON = java.sql.SQLException: ORA-00604: error occurred at recursive SQL
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int)(userId=6,sessionMode='null','B05B3112A9DFB0DEE040A8C014004A1B24567150843604980614305290700427'); REASON = java.sql.SQLException: ORA-04027: self-deadlock during automatic validation for object APPS.FND_CRYPTO ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 353 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 455 ORA-06512: at line 1 ; ERRNO = 4027; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:974)
at oracle.apps.fnd.framework.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:866)
at oracle.apps.fnd.framework.webui.OAPageBean.validateUser(OAPageBean.java:4572)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:687)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
at oa_html._OA._jspService(_OA.java:88)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
6 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.