oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select * from omaxe_work_order_headers where work_order_number is not null) QRSLT WHERE (PROJECT_NAME =:1 AND CONTRACTOR_NAME=:2)

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

    How to set two Conditions Simultaneously in set where clause

    Oracle Community | 5 years ago | user11969884
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select * from omaxe_work_order_headers where work_order_number is not null) QRSLT WHERE (PROJECT_NAME =:1 AND CONTRACTOR_NAME=:2)
  2. 0

    java.lang.ArrayIndexOutOfBoundsException when retainAM is set to true

    Oracle Community | 9 years ago | 581840
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 2
  3. 0

    Exception while using CallableStatement.execute()

    Oracle Community | 1 decade ago | Amit Goyal
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error in simple form

    Oracle Community | 1 decade ago | 534328
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT FirstFormEO.UNAME, FirstFormEO.PASSWORD, FirstFormEO.LAST_UPDATE_LOGIN, FirstFormEO.LAST_UPDATED_BY, FirstFormEO.LAST_UPDATE_DATE, FirstFormEO.CREATED_BY, FirstFormEO.CREATION_DATE FROM LOGIN FirstFormEO
  6. 0

    Nullpointerexception ....

    Oracle Community | 10 years ago | 572444
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    2 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.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select * from omaxe_work_order_headers where work_order_number is not null) QRSLT WHERE (PROJECT_NAME =:1 AND CONTRACTOR_NAME=:2)

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:210)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:152)
      6. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:721)
      6 frames
    3. omaxe.oracle.apps
      OmaxeDPRCO.processFormRequest
      1. omaxe.oracle.apps.xxopa.boqmain.webui.OmaxeDPRCO.processFormRequest(OmaxeDPRCO.java:107)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:799)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1118)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2633)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
      18 frames