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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 829058, 1 year 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 user2626293, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ppd.segment2 position_number, ppd.segment3 position_title, papf.full_name employee_name, haou1.NAME budget_centre, haou1.organization_id
via Oracle Community by 577440, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select effective_date||' - '|| pay_us_employee_payslip_web.get_meaning_payslip_label(:1||'', 'JOB')||' '|| action_information14
via Oracle Community by User549949-Oracle, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.eng.changemgmt.common.server.QuickSearchTypesVO of type View Definition not found
via Oracle Community by 715932, 1 year ago
oracle.adf.mds.exception.MDSRuntimeException: Unable to find component with absolute reference = /oracle/apps/icx/icatalog/authoring/webui/LoadOptionsPG.xxtn/oracle/apps/icx/tui/lov/webui/xxOpUnitsWithAllOULovRN, XML Path = null. Please verify that the reference is valid and the definition of the component exists either on the File System or in the MDS Repository.
via Oracle Community by chintu, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.hxc.selfservice.timecard.server.xxaseJobOsnRsnVO of type View Definition not found
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.