oracle.jbo.SQLStmtException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Design Gererator issue
    via by 437234,
  • setWhereClauseParam
    via by BabakSaraie,
  • [SOLVED]Connecting DB problem
    via by soso_xuc,
  • socket error/ where-clause
    via by 100443,
  • ORA-01866
    via by 771205,
  • ORA-01866
    via by 771205,
    • 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)

    Users with the same issue

    Unknown visitor1 times, last one,