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 | 7 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

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

    Oracle Community | 7 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

    Invalid column index :RTE after adding eo/vo attributes

    Oracle Community | 9 years ago | 593191
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ContactEO.ROW_ID, ContactEO.FST_NAME, ContactEO.LAST_NAME, ContactEO.CELL_PH_NUM, ContactEO.EMAIL_ADDR, ContactEO.FAX_PH_NUM, ContactEO.HOME_PH_NUM, ContactEO.JOB_TITLE, ContactEO.MID_NAME, ContactEO.OWNER_PER_ID, ContactEO.PER_TITLE, ContactEO.WORK_PH_NUM, ContactEO.MODIFICATION_NUM, ContactEO.CREDIT_SCORE, OrgExtEO.NAME, OrgExtEO.ROW_ID AS ROW_ID11, OrgExtEO.MODIFICATION_NUM AS MODIFICATION_NUM1, OrgExtEO.LOC FROM S_PARTY PartyEO, S_CONTACT ContactEO, S_ORG_EXT OrgExtEO, S_PARTY_PER PartyPerEO WHERE (PartyEO.ROW_ID = ContactEO.PAR_ROW_ID) AND ((ContactEO.ROW_ID = PartyPerEO.PERSON_ID(+)) AND (PartyPerEO.PARTY_ID = OrgExtEO.ROW_ID(+)))
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 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

    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