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

Oracle Community | 788094 | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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 user_id user_id from apps.fnd_user where user_name =:SSOUse rName
  2. 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
  3. 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(+)))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  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 user_id user_id from apps.fnd_user where user_name =:SSOUse rName

      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.utils.LifecycleUtils.getUserInfo(LifecycleUtils.java:129)
      2. od.adf.common.fwk.aif.security.lifecycle.SecurityFacesPageLifecycle.loadSessionObj(SecurityFacesPageLifecycle.java:210)
      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