oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoRequisitionSupplierEO.REQUISITION_LINE_ID, PoRequisitionSupplierEO.VENDOR_ID, PoRequisitionSupplierEO.VENDOR_SITE_ID, PoRequisitionSupplierEO.VENDOR_CONTACT_ID, PoRequisitionSupplierEO.NOTE_TO_VENDOR, PoRequisitionSupplierEO.DOCUMENT_TYPE_CODE, PoRequisitionSupplierEO.SOURCE_DOC_HEADER_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_NUM, PoRequisitionSupplierEO.UNIT_PRICE, PoRequisitionSupplierEO.CURRENCY_UNIT_PRICE, PoRequisitionSupplierEO.AMOUNT, PoRequisitionSupplierEO.CURRENCY_AMOUNT, PoRequisitionSupplierEO.CURRENCY_CODE, PoRequisitionSupplierEO.RATE_TYPE, PoRequisitionSupplierEO.RATE_DATE, PoRequisitionSupplierEO.RATE, PoRequisitionSupplierEO.PRICE_BREAK_ID, PoRequisitionSupplierEO.NOT_TO_EXCEED_PRICE, PoRequisitionSupplierEO.ALLOW_PRICE_OVERRIDE_FLAG, PoRequisitionSupplierEO.ALLOW_RATE_DIFFERENTIAL_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_DATE, PoRequisitionSupplierEO.LAST_UPDATE_DATE, PoRequisitionSupplierEO.LAST_UPDATED_BY, PoRequisitionSupplierEO.LAST_UPDATE_LOGIN, PoRequisitionSupplierEO.CREATION_DATE, PoRequisitionSupplierEO.CREATED_BY, PoRequisitionSupplierEO.REQUISITION_SUPPLIER_ID, PoRequisitionSupplierEO.ROWID, PoRequisitionSupplierEO.CANDIDATE_FIRST_NAME, PoRequisitionSupplierEO.CANDIDATE_LAST_NAME, PoRequisitionSupplierEO.UNIT_MEAS_LOOKUP_CODE FROM PO_REQUISITION_SUPPLIERS PoRequisitionSupplierEO WHERE (UnitMeasLookupCode = :2PoRequisitionSupplierEO.RATE = :2) AND PoRequisitionSupplierEO.REQUISITION_LINE_ID = :1

Oracle Community | Sandeep Oracle | 6 years ago
  1. 0

    Getting Error while trying to dynamically extending  the VO through Control

    Oracle Community | 6 years ago | Sandeep Oracle
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoRequisitionSupplierEO.REQUISITION_LINE_ID, PoRequisitionSupplierEO.VENDOR_ID, PoRequisitionSupplierEO.VENDOR_SITE_ID, PoRequisitionSupplierEO.VENDOR_CONTACT_ID, PoRequisitionSupplierEO.NOTE_TO_VENDOR, PoRequisitionSupplierEO.DOCUMENT_TYPE_CODE, PoRequisitionSupplierEO.SOURCE_DOC_HEADER_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_NUM, PoRequisitionSupplierEO.UNIT_PRICE, PoRequisitionSupplierEO.CURRENCY_UNIT_PRICE, PoRequisitionSupplierEO.AMOUNT, PoRequisitionSupplierEO.CURRENCY_AMOUNT, PoRequisitionSupplierEO.CURRENCY_CODE, PoRequisitionSupplierEO.RATE_TYPE, PoRequisitionSupplierEO.RATE_DATE, PoRequisitionSupplierEO.RATE, PoRequisitionSupplierEO.PRICE_BREAK_ID, PoRequisitionSupplierEO.NOT_TO_EXCEED_PRICE, PoRequisitionSupplierEO.ALLOW_PRICE_OVERRIDE_FLAG, PoRequisitionSupplierEO.ALLOW_RATE_DIFFERENTIAL_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_DATE, PoRequisitionSupplierEO.LAST_UPDATE_DATE, PoRequisitionSupplierEO.LAST_UPDATED_BY, PoRequisitionSupplierEO.LAST_UPDATE_LOGIN, PoRequisitionSupplierEO.CREATION_DATE, PoRequisitionSupplierEO.CREATED_BY, PoRequisitionSupplierEO.REQUISITION_SUPPLIER_ID, PoRequisitionSupplierEO.ROWID, PoRequisitionSupplierEO.CANDIDATE_FIRST_NAME, PoRequisitionSupplierEO.CANDIDATE_LAST_NAME, PoRequisitionSupplierEO.UNIT_MEAS_LOOKUP_CODE FROM PO_REQUISITION_SUPPLIERS PoRequisitionSupplierEO WHERE (UnitMeasLookupCode = :2PoRequisitionSupplierEO.RATE = :2) AND PoRequisitionSupplierEO.REQUISITION_LINE_ID = :1
  2. 0

    Fnd Load Issue

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;
  3. 0

    db:: 3.55::FND_MESSAGE.PUT 1c

    hivmr.com | 8 months ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SEPL and VO Extension

    Oracle Community | 9 years ago | 567494
    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = xxEYReqSummaryVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;
  6. 0

    Tycast error in Extension

    Oracle Community | 8 years ago | 568541
    oracle.apps.fnd.framework.OAException: The application id or shortname (abc) you entered does not exist.

    11 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 PoRequisitionSupplierEO.REQUISITION_LINE_ID, PoRequisitionSupplierEO.VENDOR_ID, PoRequisitionSupplierEO.VENDOR_SITE_ID, PoRequisitionSupplierEO.VENDOR_CONTACT_ID, PoRequisitionSupplierEO.NOTE_TO_VENDOR, PoRequisitionSupplierEO.DOCUMENT_TYPE_CODE, PoRequisitionSupplierEO.SOURCE_DOC_HEADER_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_NUM, PoRequisitionSupplierEO.UNIT_PRICE, PoRequisitionSupplierEO.CURRENCY_UNIT_PRICE, PoRequisitionSupplierEO.AMOUNT, PoRequisitionSupplierEO.CURRENCY_AMOUNT, PoRequisitionSupplierEO.CURRENCY_CODE, PoRequisitionSupplierEO.RATE_TYPE, PoRequisitionSupplierEO.RATE_DATE, PoRequisitionSupplierEO.RATE, PoRequisitionSupplierEO.PRICE_BREAK_ID, PoRequisitionSupplierEO.NOT_TO_EXCEED_PRICE, PoRequisitionSupplierEO.ALLOW_PRICE_OVERRIDE_FLAG, PoRequisitionSupplierEO.ALLOW_RATE_DIFFERENTIAL_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_DATE, PoRequisitionSupplierEO.LAST_UPDATE_DATE, PoRequisitionSupplierEO.LAST_UPDATED_BY, PoRequisitionSupplierEO.LAST_UPDATE_LOGIN, PoRequisitionSupplierEO.CREATION_DATE, PoRequisitionSupplierEO.CREATED_BY, PoRequisitionSupplierEO.REQUISITION_SUPPLIER_ID, PoRequisitionSupplierEO.ROWID, PoRequisitionSupplierEO.CANDIDATE_FIRST_NAME, PoRequisitionSupplierEO.CANDIDATE_LAST_NAME, PoRequisitionSupplierEO.UNIT_MEAS_LOOKUP_CODE FROM PO_REQUISITION_SUPPLIERS PoRequisitionSupplierEO WHERE (UnitMeasLookupCode = :2PoRequisitionSupplierEO.RATE = :2) AND PoRequisitionSupplierEO.REQUISITION_LINE_ID = :1

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:612)
      3. oracle.apps.fnd.framework.webui.OAWebBeanTableHelper.processRequest(OAWebBeanTableHelper.java:2141)
      4. oracle.apps.fnd.framework.webui.beans.table.OATableBean.processRequest(OATableBean.java:1035)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      9. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      19. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      24. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
      25. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      29. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      30. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      33. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      34. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      35. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      36. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2514)
      37. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1895)
      38. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:539)
      39. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:427)
      39 frames