oracle.jbo.SQLStmtException

JBO-27122: SQL error during statement preparation. Statement: select user_id user_id from apps.fnd_user where user_name =:SSOUse rName

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web46

  • via Oracle Community by 788094, 11 months ago
    JBO-27122: SQL error during statement preparation. Statement: select user_id user_id from apps.fnd_user where user_name =:SSOUse rName
  • JBO-27122: SQL error during statement preparation. Statement: select first_name,last_name from employees where email=:p_email
  • JBO-27122: SQL error during statement preparation. Statement: SELECT blah, blah FROM MYTABLE MyTableEo WHERE ? = MyTableEo.LINKCOLUMN
  • Stack trace

    • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select user_id user_id from apps.fnd_user where user_name =:SSOUse rName 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.utils.LifecycleUtils.getUserInfo(LifecycleUtils.java:129) at od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle.loadSessionObj(SecurityFacesPageLifecycle.java:210) 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago