oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select ppf.person_id, ppf.employee_number, god.organization_id, ppf.full_name employee_name, (select full_name from per_people_x where person_id = paf.supervisor_ID ) manager_name, (select full_name from per_people_x where person_id = haou.attribute4 ) hr_name, --hr_general.decode_person_name(haou.attribute4 ) hr_name, haou.name organization_name, GEM.termination_date actual_termination_date, (select meaning from hr_lookups where lookup_type = 'LEAV_REAS' and lookup_code = GEM.Leaving_reason and enabled_flag = 'Y') leaving_reason, god.sub_business sub_business, god.business_segment business_segment, god.industry_focus_group industry_focus_group, pgd.segment2 corporate_Band, tl.territory_short_name country from per_people_f ppf, per_assignments_f paf, hr_all_organization_units haou, per_grades pg, per_grade_definitions pgd, per_addresses pa, fnd_territories_tl tl, XXsm_org_dtl god, XX_EXIT_TRANSACTION GET, XX_EXIT_MANAGER GEM where 1=1 and paf.person_id=:1 and paf.primary_flag='Y' and ppf.person_id = paf.person_id and paf.organization_id=haou.organization_id and paf.organization_id = god.organization_id and trunc(sysdate) between trunc(paf.effective_start_date) and trunc(paf.effective_end_date) and trunc(sysdate) between trunc(ppf.effective_start_date) and trunc(ppf.effective_end_date) and ppf.person_id=GET.employee_id(+) and GET.Transaction_id = GEM.transaction_id and paf.grade_id=pg.grade_id(+) and pg.grade_definition_id=pgd.grade_definition_id(+) and ppf.person_id=pa.person_id(+) and pa.primary_flag(+)='Y' and pa.country=tl.territory_code(+) AND tl.language = USERENV('LANG') AND trunc(sysdate) between trunc(pa.Date_from) and trunc(nvl(pa.Date_to, TO_DATE ('31-DEC-4712', 'DD-MON-YYYY')))

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by Avaneesh Jain, 1 year ago
, pgd.segment2 corporate_Band, tl.territory_short_name country from per_people_f ppf, per_assignments_f paf, hr_all_organization_units haou, per_grades pg, per_grade_definitions pgd, per_addresses pa, fnd_territories_tl tl, XXsm_org_dtl god
via Oracle Community by 610323, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: /* Formatted on 2009/07/24 10:39 (Formatter Plus v4.8.0) */ SELECT pen.prtt_enrt_rslt_id, pcs.enrt_ctfn_typ_cd, hl1.meaning certification_type
via Oracle Community by 610323, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pen.prtt_enrt_rslt_id, pcs.enrt_ctfn_typ_cd, hl1.meaning certification_type, pen.sspndd_flag suspended_flag, pcs.enrt_ctfn_rqd_flag required_flag
via hivmr.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: /* Formatted on 2009/07/24 10:39 (Formatter Plus v4.8.0) */ SELECT pen.prtt_enrt_rslt_id, pcs.enrt_ctfn_typ_cd, hl1.meaning certification_type
via Oracle Community by 636775, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition SEGMENT2 of type Attribute not found
via Oracle Community by 588819, 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 ppf.person_id, ppf.employee_number, god.organization_id, ppf.full_name employee_name, (select full_name from per_people_x where person_id = paf.supervisor_ID ) manager_name, (select full_name from per_people_x where person_id = haou.attribute4 ) hr_name, --hr_general.decode_person_name(haou.attribute4 ) hr_name, haou.name organization_name, GEM.termination_date actual_termination_date, (select meaning from hr_lookups where lookup_type = 'LEAV_REAS' and lookup_code = GEM.Leaving_reason and enabled_flag = 'Y') leaving_reason, god.sub_business sub_business, god.business_segment business_segment, god.industry_focus_group industry_focus_group, pgd.segment2 corporate_Band, tl.territory_short_name country from per_people_f ppf, per_assignments_f paf, hr_all_organization_units haou, per_grades pg, per_grade_definitions pgd, per_addresses pa, fnd_territories_tl tl, XXsm_org_dtl god, XX_EXIT_TRANSACTION GET, XX_EXIT_MANAGER GEM where 1=1 and paf.person_id=:1 and paf.primary_flag='Y' and ppf.person_id = paf.person_id and paf.organization_id=haou.organization_id and paf.organization_id = god.organization_id and trunc(sysdate) between trunc(paf.effective_start_date) and trunc(paf.effective_end_date) and trunc(sysdate) between trunc(ppf.effective_start_date) and trunc(ppf.effective_end_date) and ppf.person_id=GET.employee_id(+) and GET.Transaction_id = GEM.transaction_id and paf.grade_id=pg.grade_id(+) and pg.grade_definition_id=pgd.grade_definition_id(+) and ppf.person_id=pa.person_id(+) and pa.primary_flag(+)='Y' and pa.country=tl.territory_code(+) AND tl.language = USERENV('LANG') AND trunc(sysdate) between trunc(pa.Date_from) and trunc(nvl(pa.Date_to, TO_DATE ('31-DEC-4712', 'DD-MON-YYYY')))
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:750)
at ge.oracle.apps.per.selfservice.eexit.employee.webui.GEExitEmployeeCO.processRequest(GEExitEmployeeCO.java:112)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
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.form.OAFormBean.processRequest(OAFormBean.java:385)
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:2348)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747)
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 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
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.