1 Reply Latest reply on Feb 18, 2011 1:05 PM by 824236

    JBO-27122: SQL error during statement preparation in OAS 10.1.3.4

    788094
      Hi All,
      Please help me with this issue.
      when we try to access an application, the page refreshes and stays back.
      Below are the following errors I did see in the logs.
      Please help me to resolve this .



      od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle loadValidResponsibilities
      SEVERE: Failed at loadValidResponsibilities():
      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)
      ## Detail 0 ##
      java.sql.SQLException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      at oracle_jdbc_driver_T4CPreparedStatement_Proxy.executeQuery()
      at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:857)
      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)
      Jul 30, 2010 9:26:03 AM od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle loadSessionObj
      SEVERE: Failed at loadingSessionObj.. -error: JBO-27122: SQL error during statement preparation. Statement: select user_id user_id from apps
      .fnd_user where user_name =:SSOUserName
      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)
      ## Detail 0 ##
      java.sql.SQLException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      at oracle_jdbc_driver_T4CPreparedStatement_Proxy.executeQuery()
      at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:857)
      at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666)
      at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655)