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')))

Oracle Community | Avaneesh Jain | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    ERROR java.sql.SQLException: ORA-01843: not a valid month

    Oracle Community | 6 years ago | Avaneesh Jain
    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')))
  2. 0

    db:: 4.01::Unable to execute compiled java script from code 9j

    hivmr.com | 12 months ago
    oracle.apps.fnd.framework.OAException: 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, pen.sspndd_flag suspended_flag, pcs.enrt_ctfn_rqd_flag required_flag, pcs.enrt_ctfn_recd_dt received_date, pcs.enrt_ctfn_dnd_dt denied_date, blf.NAME life_event, pen.effective_start_date, DECODE (pen.effective_end_date, TO_DATE ('12-31-4712', 'mm-dd-yyyy'), NULL, TO_CHAR (pen.effective_end_date, 'mm/dd/yyyy') ) effective_end_date, bpf.NAME plan_name, bof.NAME option_name, hl2.meaning due_to FROM ben_prtt_enrt_ctfn_prvdd_f pcs, hr_lookups hl1, hr_lookups hl2, ben_prtt_enrt_rslt_f pen, ben_pl_f bpf, ben_oipl_f boipl, ben_opt_f bof, ben_ler_f blf, ben_per_in_ler pil WHERE 1 = 1 AND pen.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id AND pcs.enrt_ctfn_typ_cd = hl1.lookup_code(+) AND hl1.lookup_type(+) = 'BEN_ENRT_CTFN_TYP' AND pcs.enrt_r_bnft_ctfn_cd = hl2.lookup_code(+) AND hl2.lookup_type(+) = 'BEN_ENRT_R_BNFT_CTFN' AND pen.ler_id = blf.ler_id(+) AND pen.pl_id = bpf.pl_id(+) AND pen.oipl_id = boipl.oipl_id(+) AND boipl.opt_id = bof.opt_id(+) AND pen.per_in_ler_id = pil.per_in_ler_id(+) AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT') AND pen.person_id = :1 ORDER BY received_date
  3. 0

    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparat

    Oracle Community | 8 years ago | 610323
    oracle.apps.fnd.framework.OAException: 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, pcs.enrt_ctfn_recd_dt received_date, pcs.enrt_ctfn_dnd_dt denied_date, blf.NAME life_event, pen.effective_start_date, DECODE (pen.effective_end_date, TO_DATE ('12-30-4712', 'mm-dd-yyyy'), NULL,TO_CHAR (pen.effective_end_date, 'dd/mm/yyyy') ) effective_end_date, bpf.NAME plan_name, bof.NAME option_name, hl2.meaning due_to FROM ben_prtt_enrt_ctfn_prvdd_f pcs, hr_lookups hl1, hr_lookups hl2, ben_prtt_enrt_rslt_f pen, ben_pl_f bpf, ben_oipl_f boipl, ben_opt_f bof, ben_ler_f blf, ben_per_in_ler pil WHERE 1 = 1 AND pen.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id AND pcs.enrt_ctfn_typ_cd = hl1.lookup_code(+) AND hl1.lookup_type(+) = 'BEN_ENRT_CTFN_TYP' AND pcs.enrt_r_bnft_ctfn_cd = hl2.lookup_code(+) AND hl2.lookup_type(+) = 'BEN_ENRT_R_BNFT_CTFN' AND pen.ler_id = blf.ler_id(+) AND pen.pl_id = bpf.pl_id(+) AND pen.oipl_id = boipl.oipl_id(+) AND boipl.opt_id = bof.opt_id(+) AND pen.per_in_ler_id = pil.per_in_ler_id(+) AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT') AND pen.person_id = :1 ORDER BY received_date
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL error during statement preparation

    Oracle Community | 8 years ago | 610323
    oracle.apps.fnd.framework.OAException: 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, pen.sspndd_flag suspended_flag, pcs.enrt_ctfn_rqd_flag required_flag, pcs.enrt_ctfn_recd_dt received_date, pcs.enrt_ctfn_dnd_dt denied_date, blf.NAME life_event, pen.effective_start_date, DECODE (pen.effective_end_date, TO_DATE ('12-31-4712', 'mm-dd-yyyy'), NULL, TO_CHAR (pen.effective_end_date, 'mm/dd/yyyy') ) effective_end_date, bpf.NAME plan_name, bof.NAME option_name, hl2.meaning due_to FROM ben_prtt_enrt_ctfn_prvdd_f pcs, hr_lookups hl1, hr_lookups hl2, ben_prtt_enrt_rslt_f pen, ben_pl_f bpf, ben_oipl_f boipl, ben_opt_f bof, ben_ler_f blf, ben_per_in_ler pil WHERE 1 = 1 AND pen.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id AND pcs.enrt_ctfn_typ_cd = hl1.lookup_code(+) AND hl1.lookup_type(+) = 'BEN_ENRT_CTFN_TYP' AND pcs.enrt_r_bnft_ctfn_cd = hl2.lookup_code(+) AND hl2.lookup_type(+) = 'BEN_ENRT_R_BNFT_CTFN' AND pen.ler_id = blf.ler_id(+) AND pen.pl_id = bpf.pl_id(+) AND pen.oipl_id = boipl.oipl_id(+) AND boipl.opt_id = bof.opt_id(+) AND pen.per_in_ler_id = pil.per_in_ler_id(+) AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT') AND pen.person_id = :1 ORDER BY received_date
  6. 0

    Java Error when Clicking on Notification

    Oracle Community | 7 years ago | 543461
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT avt.version_name Course_Name *,oft.name Offering_Name* *,ctt.category Delivery_Name* *,ota_utility.get_lang_name(ofs.language_code) Language* *,ent.title Class_Name* *,lkp.meaning Status* *,evt.course_start_date StartDate* *,evt.course_end_date EndDate * *,nvl(evt.course_start_time,'00:00') StartTime* *,nvl(evt.course_end_time,'23:59') EndTime* *,ftl.name Timezone* *,ota_general.get_location_code(evt.location_id) Location_Name* *,evt.actual_cost || ' ' || ota_general.fnd_currency_name(evt.budget_currency_code) cost* *,evt.event_type event_type* FROM ota_events evt *,ota_events_tl ent* *,ota_activity_versions_tl avt* *,ota_offerings ofs* *,ota_offerings_tl oft* *,ota_category_usages_tl ctt* *,hr_lookups lkp* *,fnd_timezones_tl ftl* WHERE evt.event_id = ent.event_id AND ent.language = userenv('LANG') AND evt.activity_version_id = avt.activity_version_id AND avt.language = userenv('LANG') AND ofs.offering_id = evt.parent_offering_id AND ofs.offering_id = oft.offering_id AND oft.language = userenv('LANG') AND ofs.delivery_mode_id = ctt.category_usage_id AND ctt.language = userenv('LANG') AND lkp.lookup_type = 'SCHEDULED_EVENT_STATUS' AND lkp.lookup_code = evt.event_status AND ftl.timezone_code = evt.timezone AND ftl.language = userenv('LANG') AND evt.event_id = :1

    2 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 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()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      6. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:750)
      6 frames
    3. ge.oracle.apps
      GEExitEmployeeCO.processRequest
      1. ge.oracle.apps.per.selfservice.eexit.employee.webui.GEExitEmployeeCO.processRequest(GEExitEmployeeCO.java:112)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
      18 frames
    5. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:84)
      1 frame
    6. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    7. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    8. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    10. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame