oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT AERL.* FROM ap_expense_report_params_all AERP ,ap_expense_report_headers_all AERH ,ap_expense_report_lines_all AERL ,ap_pol_headers APH ,ap_pol_locations_tl APLT ,fnd_lookup_values FLV WHERE AERP.expense_report_id = AERH.expense_report_id AND AERP.org_id = AERH.org_id AND AERL.report_header_id = AERH.report_header_id AND AERL.web_parameter_id = AERP.parameter_id AND AERP.company_policy_id = APH.policy_id AND AERL.location_id = APLT.location_id AND FLV.lookup_code = AERP.category_code AND FLV.lookup_type = 'OIE_EXPENSE_CATEGORY' AND FLV.language = 'US' AND APLT.language = 'US' AND AERH.report_header_id = :1

Oracle Community | CSK | 5 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

    JBO-27122: Error when Embeding Custom Region

    Oracle Community | 5 years ago | CSK
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT AERL.* FROM ap_expense_report_params_all AERP ,ap_expense_report_headers_all AERH ,ap_expense_report_lines_all AERL ,ap_pol_headers APH ,ap_pol_locations_tl APLT ,fnd_lookup_values FLV WHERE AERP.expense_report_id = AERH.expense_report_id AND AERP.org_id = AERH.org_id AND AERL.report_header_id = AERH.report_header_id AND AERL.web_parameter_id = AERP.parameter_id AND AERP.company_policy_id = APH.policy_id AND AERL.location_id = APLT.location_id AND FLV.lookup_code = AERP.category_code AND FLV.lookup_type = 'OIE_EXPENSE_CATEGORY' AND FLV.language = 'US' AND APLT.language = 'US' AND AERH.report_header_id = :1
  2. 0

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

    hivmr.com | 10 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 | 7 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 AERL.* FROM ap_expense_report_params_all AERP ,ap_expense_report_headers_all AERH ,ap_expense_report_lines_all AERL ,ap_pol_headers APH ,ap_pol_locations_tl APLT ,fnd_lookup_values FLV WHERE AERP.expense_report_id = AERH.expense_report_id AND AERP.org_id = AERH.org_id AND AERL.report_header_id = AERH.report_header_id AND AERL.web_parameter_id = AERP.parameter_id AND AERP.company_policy_id = APH.policy_id AND AERL.location_id = APLT.location_id AND FLV.lookup_code = AERP.category_code AND FLV.lookup_type = 'OIE_EXPENSE_CATEGORY' AND FLV.language = 'US' AND APLT.language = 'US' AND AERH.report_header_id = :1

      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. xxiExpensesTable.oracle.apps
      xxiExpensesTableCO.processRequest
      1. xxiExpensesTable.oracle.apps.ap.oie.audit.webui.xxiExpensesTableCO.processRequest(xxiExpensesTableCO.java:35)
      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.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      7. oracle.apps.fnd.framework.webui.OAFlexibleContentHelper.processRequest(OAFlexibleContentHelper.java:504)
      8. oracle.apps.fnd.framework.webui.beans.OAFlexibleContentBean.processRequest(OAFlexibleContentBean.java:356)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      12. oracle.apps.fnd.framework.webui.beans.layout.OAFlexibleLayoutBean.processRequest(OAFlexibleLayoutBean.java:357)
      13. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      16. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      17. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389)
      18. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      19. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      21. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHideShowHelper.processRequest(OAWebBeanHideShowHelper.java:106)
      23. oracle.apps.fnd.framework.webui.OADefaultHideShowHelper.processRequest(OADefaultHideShowHelper.java:126)
      24. oracle.apps.fnd.framework.webui.beans.layout.OADefaultHideShowBean.processRequest(OADefaultHideShowBean.java:488)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      28. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      29. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      33. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      34. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389)
      35. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      36. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      37. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      38. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      39. oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(OAFlowLayoutBean.java:351)
      40. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      41. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      42. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      43. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      44. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      45. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      46. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      47. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      48. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      49. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
      50. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      51. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      52. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      53. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      54. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      55. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      56. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      57. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      58. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      59. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      60. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      61. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2360)
      62. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1759)
      63. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
      64. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
      64 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. oracle.jsp.provider
      Jsp20RequestDispatcher.forward
      1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
      1 frame
    11. oracle.jsp.runtime
      OraclePageContext.forward
      1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
      1 frame
    12. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:94)
      1 frame
    13. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    14. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    15. 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
    16. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    17. 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
    18. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame