oracle.apps.fnd.framework.OAException: 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 budget_centre_id, hapf.position_id position_id, haou.organization_id position_org_id, papf.person_id person_id, haou.NAME position_org_name, haou.TYPE pos_org_type FROM hr_all_organization_units haou, hr_all_organization_units haou1, hr_all_positions_f hapf, per_position_definitions ppd, per_all_people_f papf, per_all_assignments_f paaf, per_person_types ppt, per_person_type_usages_f pptuf WHERE haou.business_group_id = :0 AND hapf.business_group_id = :1 AND SYSDATE BETWEEN haou.date_from AND NVL (haou.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND SYSDATE BETWEEN haou1.date_from AND NVL (haou1.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND hapf.organization_id = haou.organization_id AND papf.person_id = paaf.person_id AND hapf.position_id = paaf.position_id AND papf.person_id = pptuf.person_id AND ppt.system_person_type = ('EMP') AND paaf.assignment_status_type_id = 1 AND ppt.person_type_id = pptuf.person_type_id AND SYSDATE BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND SYSDATE BETWEEN pptuf.effective_start_date AND pptuf.effective_end_date AND ppd.position_definition_id = hapf.position_definition_id AND haou1.organization_id = xxhr_utils_pkg.xxhr_get_parent_org_f ( haou.organization_id, 'BC', 'WHO Organization Hierarchy', SYSDATE) AND haou.organization_id IN ( SELECT organization_id_child FROM per_org_structure_elements WHERE org_structure_version_id = (SELECT MAX (posv1.org_structure_version_id) FROM per_org_structure_versions posv1, per_organization_structures pos WHERE posv1.organization_structure_id = pos.organization_structure_id AND pos.primary_structure_flag = 'Y') CONNECT BY organization_id_parent = PRIOR organization_id_child START WITH organization_id_parent = :2) UNION ALL SELECT ppd.segment2 position_number, ppd.segment3 position_title, per_emp.employee_name employee_name, haou1.NAME budget_centre, haou1.organization_id budget_centre_id, hapf.position_id position_id, haou.organization_id position_org_id, per_emp.person_id person_id, haou.NAME position_org_name, haou.TYPE pos_org_type FROM hr_all_organization_units haou, hr_all_organization_units haou1, hr_all_positions_f hapf, per_position_definitions ppd, (SELECT papf.full_name employee_name, papf.person_id person_id, paaf.position_id position_id FROM per_person_types ppt, per_person_type_usages_f pptuf, per_all_people_f papf, per_all_assignments_f paaf WHERE 1 = 1 AND SYSDATE BETWEEN pptuf.effective_start_date AND pptuf.effective_end_date AND ppt.system_person_type = ('EMP') AND ppt.person_type_id = pptuf.person_type_id AND papf.person_id = pptuf.person_id AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date AND papf.person_id = paaf.person_id AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND paaf.assignment_status_type_id = 1 AND paaf.organization_id = :3) per_emp WHERE hapf.organization_id = :4 AND haou.business_group_id = :5 AND hapf.business_group_id = :6 AND SYSDATE BETWEEN haou.date_from AND NVL (haou.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND SYSDATE BETWEEN haou1.date_from AND NVL (haou1.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND hapf.organization_id = haou.organization_id AND hapf.position_id = per_emp.position_id(+) AND SYSDATE BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND ppd.position_definition_id = hapf.position_definition_id AND haou1.organization_id = xxhr_utils_pkg.xxhr_get_parent_org_f ( haou.organization_id, 'BC', 'WHO Organization Hierarchy', SYSDATE) UNION ALL SELECT ppd.segment2 position_number, ppd.segment3 position_title, NULL employee_name, haou1.NAME budget_centre, haou1.organization_id budget_centre_id, hapf.position_id position_id, haou.organization_id position_org_id, NULL person_id, haou.NAME position_org_name, haou.TYPE pos_org_type FROM hr_all_organization_units haou, hr_all_organization_units haou1, hr_all_positions_f hapf, per_position_definitions ppd WHERE haou.business_group_id = :7 AND hapf.business_group_id = :8 AND SYSDATE BETWEEN haou.date_from AND NVL (haou.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND SYSDATE BETWEEN haou1.date_from AND NVL (haou1.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND hapf.organization_id = haou.organization_id AND SYSDATE BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND ppd.position_definition_id = hapf.position_definition_id AND haou1.organization_id = xxhr_utils_pkg.xxhr_get_parent_org_f ( haou.organization_id, 'BC', 'WHO Organization Hierarchy', SYSDATE) AND NOT EXISTS (SELECT 'c' FROM per_person_types ppt, per_person_type_usages_f pptuf, per_all_people_f papf, per_all_assignments_f paaf WHERE 1 = 1 AND SYSDATE BETWEEN pptuf.effective_start_date AND pptuf.effective_end_date AND ppt.system_person_type = ('EMP') AND ppt.person_type_id = pptuf.person_type_id AND papf.person_id = pptuf.person_id AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date AND papf.person_id = paaf.person_id AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND paaf.assignment_status_type_id = 1 AND hapf.position_id = paaf.position_id) AND haou.organization_id IN ( SELECT organization_id_child FROM per_org_structure_elements WHERE org_structure_version_id = (SELECT MAX (posv1.org_structure_version_id) FROM per_org_structure_versions posv1, per_organization_structures pos WHERE posv1.organization_structure_id = pos.organization_structure_id AND pos.primary_structure_flag = 'Y') CONNECT BY organization_id_parent = PRIOR organization_id_child START WITH organization_id_parent = :9)

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 user2626293, 1 year ago
, hr_all_organization_units haou1, hr_all_positions_f hapf, per_position_definitions ppd WHERE haou.business_group_id = :7 AND hapf.business_group_id = :8 AND SYSDATE BETWEEN haou.date_from AND NVL (haou.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND SYSDATE
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 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 chintu, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.hxc.selfservice.timecard.server.xxaseJobOsnRsnVO of type View Definition not found
via Oracle Community by 884536, 1 year ago
oracle.jbo.InvalidObjNameException: JBO-25005: Object name for type View Object is invalid
oracle.apps.fnd.framework.OAException: 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 budget_centre_id, hapf.position_id position_id, haou.organization_id position_org_id, papf.person_id person_id, haou.NAME position_org_name, haou.TYPE pos_org_type FROM hr_all_organization_units haou, hr_all_organization_units haou1, hr_all_positions_f hapf, per_position_definitions ppd, per_all_people_f papf, per_all_assignments_f paaf, per_person_types ppt, per_person_type_usages_f pptuf WHERE haou.business_group_id = :0 AND hapf.business_group_id = :1 AND SYSDATE BETWEEN haou.date_from AND NVL (haou.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND SYSDATE BETWEEN haou1.date_from AND NVL (haou1.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND hapf.organization_id = haou.organization_id AND papf.person_id = paaf.person_id AND hapf.position_id = paaf.position_id AND papf.person_id = pptuf.person_id AND ppt.system_person_type = ('EMP') AND paaf.assignment_status_type_id = 1 AND ppt.person_type_id = pptuf.person_type_id AND SYSDATE BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND SYSDATE BETWEEN pptuf.effective_start_date AND pptuf.effective_end_date AND ppd.position_definition_id = hapf.position_definition_id AND haou1.organization_id = xxhr_utils_pkg.xxhr_get_parent_org_f ( haou.organization_id, 'BC', 'WHO Organization Hierarchy', SYSDATE) AND haou.organization_id IN ( SELECT organization_id_child FROM per_org_structure_elements WHERE org_structure_version_id = (SELECT MAX (posv1.org_structure_version_id) FROM per_org_structure_versions posv1, per_organization_structures pos WHERE posv1.organization_structure_id = pos.organization_structure_id AND pos.primary_structure_flag = 'Y') CONNECT BY organization_id_parent = PRIOR organization_id_child START WITH organization_id_parent = :2) UNION ALL SELECT ppd.segment2 position_number, ppd.segment3 position_title, per_emp.employee_name employee_name, haou1.NAME budget_centre, haou1.organization_id budget_centre_id, hapf.position_id position_id, haou.organization_id position_org_id, per_emp.person_id person_id, haou.NAME position_org_name, haou.TYPE pos_org_type FROM hr_all_organization_units haou, hr_all_organization_units haou1, hr_all_positions_f hapf, per_position_definitions ppd, (SELECT papf.full_name employee_name, papf.person_id person_id, paaf.position_id position_id FROM per_person_types ppt, per_person_type_usages_f pptuf, per_all_people_f papf, per_all_assignments_f paaf WHERE 1 = 1 AND SYSDATE BETWEEN pptuf.effective_start_date AND pptuf.effective_end_date AND ppt.system_person_type = ('EMP') AND ppt.person_type_id = pptuf.person_type_id AND papf.person_id = pptuf.person_id AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date AND papf.person_id = paaf.person_id AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND paaf.assignment_status_type_id = 1 AND paaf.organization_id = :3) per_emp WHERE hapf.organization_id = :4 AND haou.business_group_id = :5 AND hapf.business_group_id = :6 AND SYSDATE BETWEEN haou.date_from AND NVL (haou.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND SYSDATE BETWEEN haou1.date_from AND NVL (haou1.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND hapf.organization_id = haou.organization_id AND hapf.position_id = per_emp.position_id(+) AND SYSDATE BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND ppd.position_definition_id = hapf.position_definition_id AND haou1.organization_id = xxhr_utils_pkg.xxhr_get_parent_org_f ( haou.organization_id, 'BC', 'WHO Organization Hierarchy', SYSDATE) UNION ALL SELECT ppd.segment2 position_number, ppd.segment3 position_title, NULL employee_name, haou1.NAME budget_centre, haou1.organization_id budget_centre_id, hapf.position_id position_id, haou.organization_id position_org_id, NULL person_id, haou.NAME position_org_name, haou.TYPE pos_org_type FROM hr_all_organization_units haou, hr_all_organization_units haou1, hr_all_positions_f hapf, per_position_definitions ppd WHERE haou.business_group_id = :7 AND hapf.business_group_id = :8 AND SYSDATE BETWEEN haou.date_from AND NVL (haou.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND SYSDATE BETWEEN haou1.date_from AND NVL (haou1.date_to, TO_DATE ('31-DEC-4712', 'DD-MON-RRRR')) AND hapf.organization_id = haou.organization_id AND SYSDATE BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND ppd.position_definition_id = hapf.position_definition_id AND haou1.organization_id = xxhr_utils_pkg.xxhr_get_parent_org_f ( haou.organization_id, 'BC', 'WHO Organization Hierarchy', SYSDATE) AND NOT EXISTS (SELECT 'c' FROM per_person_types ppt, per_person_type_usages_f pptuf, per_all_people_f papf, per_all_assignments_f paaf WHERE 1 = 1 AND SYSDATE BETWEEN pptuf.effective_start_date AND pptuf.effective_end_date AND ppt.system_person_type = ('EMP') AND ppt.person_type_id = pptuf.person_type_id AND papf.person_id = pptuf.person_id AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date AND papf.person_id = paaf.person_id AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND paaf.assignment_status_type_id = 1 AND hapf.position_id = paaf.position_id) AND haou.organization_id IN ( SELECT organization_id_child FROM per_org_structure_elements WHERE org_structure_version_id = (SELECT MAX (posv1.org_structure_version_id) FROM per_org_structure_versions posv1, per_organization_structures pos WHERE posv1.organization_structure_id = pos.organization_structure_id AND pos.primary_structure_flag = 'Y') CONNECT BY organization_id_parent = PRIOR organization_id_child START WITH organization_id_parent = :9)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:603)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processRequest(OAListOfValuesHelper.java:439)
at oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processRequest(OAListOfValuesBean.java:413)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2373)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1759)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
at oa_html._OA._jspService(_OA.java:84)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:619)

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.