oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT FND_USER.USER_NAME ,FND_RESPONSIBILITY.RESPONSIBILITY_ID ,FND_RESPONSIBILITY.APPLICATION_ID ,FND_USER.USER_ID FROM apps.FND_USER_RESP_GROUPS ,apps.FND_USER ,apps.FND_RESPONSIBILITY ,apps.FND_RESPONSIBILITY_TL ,apps.FND_APPLICATION WHERE FND_USER_RESP_GROUPS.USER_ID = FND_USER.USER_ID AND FND_USER_RESP_GROUPS.RESPONSIBILITY_ID = FND_RESPONSIBILITY.RESPONSIBILITY_ID AND FND_USER_RESP_GROUPS.RESPONSIBILITY_APPLICATION_ID = FND_RESPONSIBILITY.APPLICATION_ID AND FND_RESPONSIBILITY.APPLICATION_ID=FND_RESPONSIBILITY_TL.APPLICATION_ID AND FND_RESPONSIBILITY.RESPONSIBILITY_ID=FND_RESPONSIBILITY_TL.RESPONSIBILITY_ID AND FND_USER.USER_NAME=:SSOUserName AND FND_RESPONSIBILITY.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID AND FND_APPLICATION.APPLICATION_SHORT_NAME IN (SELECT FLV.LOOKUP_CODE APPL_NAME FROM apps.FND_LOOKUP_VALUES FLV WHERE FLV.LOOKUP_TYPE = 'XXADF_APPLICATIONS' AND FLV.ENABLED_FLAG= 'Y' and flv.language= (select language_code from apps.fnd_languages where installed_fla g ='B'))

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 788094, 1 year ago
FND_RESPONSIBILITY.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID AND FND_APPLICATION.APPLICATION_SHORT_NAME IN (SELECT FLV.LOOKUP_CODE APPL_NAME FROM apps.FND_LOOKUP_VALUES FLV WHERE FLV.LOOKUP_TYPE = 'XXADF_APPLICATIONS' AND FLV.ENABLED_FLAG= 'Y' and flv.language= (select language_code from apps.fnd_languages where installed_fla g ='B'))
via Oracle Community by 405435, 7 months ago
JBO-27122: SQL error during statement preparation. Statement: select dummy from my_table
via Oracle Community by 771205, 1 year ago
JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT EOUsuario.U_ID, EOUsuario.U_NOMBRE_USUARIO, EOUsuario.U_EMAIL, EOUsuario.U_ADMIN_SEGURIDAD, EOUsuario.U_ADMIN_SISTEMA
via Oracle Community by 771205, 1 year ago
JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT EOUsuario.U_ID, EOUsuario.U_NOMBRE_USUARIO, EOUsuario.U_EMAIL, EOUsuario.U_ADMIN_SEGURIDAD, EOUsuario.U_ADMIN_SISTEMA, EOUsuario.U_PASSWORD, EOUsuario.U_TOKEN
via Oracle Community by arubelj, 8 months ago
JBO-27122: SQL error during statement preparation. Statement: select user_id user_id from apps.fnd_user where user_name =:SSOUse rName
via Oracle Community by 793149, 5 months ago
JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-27122. Error message parameters are {0=SELECT * FROM
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT FND_USER.USER_NAME
,FND_RESPONSIBILITY.RESPONSIBILITY_ID
,FND_RESPONSIBILITY.APPLICATION_ID
,FND_USER.USER_ID
FROM apps.FND_USER_RESP_GROUPS
,apps.FND_USER
,apps.FND_RESPONSIBILITY
,apps.FND_RESPONSIBILITY_TL
,apps.FND_APPLICATION
WHERE FND_USER_RESP_GROUPS.USER_ID = FND_USER.USER_ID
AND FND_USER_RESP_GROUPS.RESPONSIBILITY_ID = FND_RESPONSIBILITY.RESPONSIBILITY_ID
AND FND_USER_RESP_GROUPS.RESPONSIBILITY_APPLICATION_ID = FND_RESPONSIBILITY.APPLICATION_ID
AND FND_RESPONSIBILITY.APPLICATION_ID=FND_RESPONSIBILITY_TL.APPLICATION_ID
AND FND_RESPONSIBILITY.RESPONSIBILITY_ID=FND_RESPONSIBILITY_TL.RESPONSIBILITY_ID
AND FND_USER.USER_NAME=:SSOUserName
AND FND_RESPONSIBILITY.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID
AND FND_APPLICATION.APPLICATION_SHORT_NAME IN
(SELECT FLV.LOOKUP_CODE APPL_NAME
FROM apps.FND_LOOKUP_VALUES FLV
WHERE FLV.LOOKUP_TYPE = 'XXADF_APPLICATIONS'
AND FLV.ENABLED_FLAG= 'Y' and flv.language= (select language_code from apps.fnd_languages where installed_fla
g ='B'))	at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383)	at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:3972)	at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:958)	at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666)	at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655)	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)	at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:891)	at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:805)	at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:799)	at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3575)	at od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle.loadValidResponsibilities(SecurityFacesPageLifecycle.java:419)	at od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle.loadSessionObj(SecurityFacesPageLifecycle.java:208)	at od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle.prepareRender(SecurityFacesPageLifecycle.java:97)	at od.adf.cc.ui.app.CustomPageLifecycle.prepareRender(CustomPageLifecycle.java:34)	at oracle.adf.controller.v2.lifecycle.PageController.prepareRender(PageController.java:64)	at od.adf.cc.ui.controller.HomePageController.prepareRender(HomePageController.java:29)	at oracle.adf.controller.v2.lifecycle.Lifecycle$1.execute(Lifecycle.java:297)	at oracle.adf.controller.v2.lifecycle.Lifecycle.executePhase(Lifecycle.java:116)	at oracle.adf.controller.faces.lifecycle.ADFPhaseListener.mav$executePhase(ADFPhaseListener.java:29)	at oracle.adf.controller.faces.lifecycle.ADFPhaseListener$1.before(ADFPhaseListener.java:426)	at oracle.adf.controller.faces.lifecycle.ADFPhaseListener.beforePhase(ADFPhaseListener.java:77)	at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:228)	at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:137)	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:214)	at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)	at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:228)	at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:197)	at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:123)	at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:103)	at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)	at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:162)	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)	at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:889)	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)	at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)	at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)	at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)	at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)	at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)	at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)	at java.lang.Thread.run(Thread.java:619)