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

Solutions on the web1059

  • via Oracle Community by 829058, 11 months ago
    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
  • via Oracle Community by Siva Prasad Nidimamidi, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct ffvl.flex_value,ffvl.description, mcb.category_id from fnd_flex_value_sets ffvs ,fnd_flex_values_vl ffvl, mtl_categories_b mcb
  • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name
  • Stack trace

    • 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(OAException.java:896) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:612) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processRequest(OAListOfValuesHelper.java:449) at oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processRequest(OAListOfValuesBean.java:413) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2496) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1892) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates