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'))

Oracle Community | 788094 | 6 years ago
  1. 0

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

    Oracle Community | 6 years ago | 788094
    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'))
  2. 0

    JBO-27122 SQL error during Statement preparation

    Google Groups | 1 decade ago | Jeff
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Product.APPNAME, Product.PRODID, Product.DESCRIPTION, Product.PRICE, Product.THUMBNAIL, Product.DESCRIPTION_ES, Product.DESCRIPTION_FR FROM ETC.ECOM_PRODUCT Product WHERE (SPECIALCHARGE <> 'Y' OR SPECIALCHARGE IS NULL) AND APPNAME = ? AND ((DISABLED <> 'Y' OR DISABLED IS NULL)) ORDER BY PRODID
  3. 0

    Design Gererator issue

    Oracle Community | 1 decade ago | 437234
    oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. State ment: select tab.name tabName , tab.irid tabIrid , tab.table_type tab leType , tab.ivid tabIvid , mti.alias mtiAlias , mde.name mdeName , decode ( ov.state , 'O' , jr_version.get_vlabe l(ov.irid, jr_version.get_original_of_checkout( ov.irid,ov.ivid))||'CO' , 'I' , ov.vlabel , 'N' , '' , '0.0' ) versionLabel from ci_general_modules mde , ci relation definitions tab , ci_module_detail_table_usages mti , ci_m odule_component_inclusions mcn , sdd_object_versions ov where mde.ivid = .ivid and mti.module_unit_reference = mcn.module_component_reference and mti.table_reference = tab.irid and ov.ivid = tab.ivid UNION select tab.na me tabName , tab.irid tabIrid , tab.table_type tableType , tab.iv id tabIvid , mti.alias mtiAlias , mde.name mdeName , decode ( ov.state , 'O' , jr_version.get_vlabel(ov.irid, jr_versio n.get_original_of_checkout( ov.irid,ov.ivid))||'CO' , 'I' , ov.vlabel , 'N' , '' , '0.0' ) versionLabel from ci_general_modules mde , ci_relation_definition s tab , ci_module_detail_table_usages mti , ci_lov_inclusions lvi , sdd_object_versions ov where mde.ivid = :1 and lvi.general_module_ref erence = mde.irid and lvi.parent_ivid = mde.ivid and mti.module_unit_ref erence = lvi.list_of_values_reference and mti.table_reference = tab.irid a nd ov.ivid = tab.ivid order by 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    setWhereClauseParam

    Oracle Community | 9 years ago | BabakSaraie
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT employeeSalary(:empID) as EmpSal FROM DUAL
  6. 0

    [SOLVED]Connecting DB problem

    Oracle Community | 9 years ago | soso_xuc
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT T.FUNCTION_ID FUNCTION_ID, T.FUNCTION_NAME FUNCTION_NAME, T.FUNCTION_URL FUNCTION_URL, T.FUNCTION_PARAMS FUNCTION_PARAMS FROM TASKS.FUNCTIONS T

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383)
      2. oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:3972)
      3. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:958)
      4. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666)
      5. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655)
      6. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
      7. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:891)
      8. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:805)
      9. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:799)
      10. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3575)
      10 frames
    3. od.adf.common
      SecurityFacesPageLifecycle.prepareRender
      1. od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle.loadValidResponsibilities(SecurityFacesPageLifecycle.java:419)
      2. od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle.loadSessionObj(SecurityFacesPageLifecycle.java:208)
      3. od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle.prepareRender(SecurityFacesPageLifecycle.java:97)
      3 frames
    4. od.adf.cc
      CustomPageLifecycle.prepareRender
      1. od.adf.cc.ui.app.CustomPageLifecycle.prepareRender(CustomPageLifecycle.java:34)
      1 frame
    5. oracle.adf.controller
      PageController.prepareRender
      1. oracle.adf.controller.v2.lifecycle.PageController.prepareRender(PageController.java:64)
      1 frame
    6. od.adf.cc
      HomePageController.prepareRender
      1. od.adf.cc.ui.controller.HomePageController.prepareRender(HomePageController.java:29)
      1 frame
    7. oracle.adf.controller
      ADFPhaseListener.beforePhase
      1. oracle.adf.controller.v2.lifecycle.Lifecycle$1.execute(Lifecycle.java:297)
      2. oracle.adf.controller.v2.lifecycle.Lifecycle.executePhase(Lifecycle.java:116)
      3. oracle.adf.controller.faces.lifecycle.ADFPhaseListener.mav$executePhase(ADFPhaseListener.java:29)
      4. oracle.adf.controller.faces.lifecycle.ADFPhaseListener$1.before(ADFPhaseListener.java:426)
      5. oracle.adf.controller.faces.lifecycle.ADFPhaseListener.beforePhase(ADFPhaseListener.java:77)
      5 frames
    8. JSF
      LifecycleImpl.render
      1. com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:228)
      2. com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:137)
      2 frames
    9. JavaEE 7
      FacesServlet.service
      1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:214)
      1 frame
    10. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    11. oracle.adfinternal.view
      AdfFacesFilterImpl.doFilter
      1. oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:228)
      2. oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:197)
      3. oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:123)
      3 frames
    12. oracle.adf.view
      AdfFacesFilter.doFilter
      1. oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:103)
      1 frame
    13. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    14. oracle.adf.model
      ADFBindingFilter.doFilter
      1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:162)
      1 frame
    15. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:889)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    16. oracle.oc4j.network
      ServerSocketAcceptHandler$AcceptHandlerHorse.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      2. oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
      3. oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
      4. oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
      4 frames
    17. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    18. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame