oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT vwh.person_id supervisor_id, MIN (vwl.amount), ppf.last_name, ppf.first_name FROM vw_po_apr_assign_hdr vwh, vw_po_apr_assign_line vwl, per_all_people_f ppf WHERE vwh.person_id = vwl.person_id AND vwh.person_id = ppf.person_id AND NVL (TO_CHAR (vwl.TO_DATE), TO_CHAR (SYSDATE, 'DD/MM/RRRR')) >=TO_CHAR (SYSDATE, 'DD/MM/RRRR') AND :1 BETWEEN vwl.cost_centre_low AND vwl.cost_centre_high AND :2 BETWEEN vwl.account_low AND vwl.account_high AND NVL(ppf.effective_end_date, SYSDATE) >= SYSDATE AND TO_CHAR (vwl.amount) >= :3 GROUP BY vwl.amount, vwh.person_id, ppf.last_name,ppf.first_name ORDER BY vwl.amount, ppf.last_name

Oracle Community | 829058 | 6 years ago
  1. 0

    Problem with VO Extension

    Oracle Community | 6 years ago | 829058
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT vwh.person_id supervisor_id, MIN (vwl.amount), ppf.last_name, ppf.first_name FROM vw_po_apr_assign_hdr vwh, vw_po_apr_assign_line vwl, per_all_people_f ppf WHERE vwh.person_id = vwl.person_id AND vwh.person_id = ppf.person_id AND NVL (TO_CHAR (vwl.TO_DATE), TO_CHAR (SYSDATE, 'DD/MM/RRRR')) >=TO_CHAR (SYSDATE, 'DD/MM/RRRR') AND :1 BETWEEN vwl.cost_centre_low AND vwl.cost_centre_high AND :2 BETWEEN vwl.account_low AND vwl.account_high AND NVL(ppf.effective_end_date, SYSDATE) >= SYSDATE AND TO_CHAR (vwl.amount) >= :3 GROUP BY vwl.amount, vwh.person_id, ppf.last_name,ppf.first_name ORDER BY vwl.amount, ppf.last_name
  2. 0

    Extending LOV

    Oracle Community | 7 years ago | 680883
    oracle.apps.fnd.framework.OAException: java.lang.NumberFormatException: For input string: ""
  3. 0

    Fnd Load Issue

    wpthm.com | 1 year 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

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

    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 vwh.person_id supervisor_id, MIN (vwl.amount), ppf.last_name, ppf.first_name FROM vw_po_apr_assign_hdr vwh, vw_po_apr_assign_line vwl, per_all_people_f ppf WHERE vwh.person_id = vwl.person_id AND vwh.person_id = ppf.person_id AND NVL (TO_CHAR (vwl.TO_DATE), TO_CHAR (SYSDATE, 'DD/MM/RRRR')) >=TO_CHAR (SYSDATE, 'DD/MM/RRRR') AND :1 BETWEEN vwl.cost_centre_low AND vwl.cost_centre_high AND :2 BETWEEN vwl.account_low AND vwl.account_high AND NVL(ppf.effective_end_date, SYSDATE) >= SYSDATE AND TO_CHAR (vwl.amount) >= :3 GROUP BY vwl.amount, vwh.person_id, ppf.last_name,ppf.first_name ORDER BY vwl.amount, ppf.last_name

      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.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      4. oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processRequest(OAListOfValuesHelper.java:449)
      5. oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processRequest(OAListOfValuesBean.java:413)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      8. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      9. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      10. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      11. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2496)
      12. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1892)
      13. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
      14. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)
      14 frames