oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select nvl2(:1, irc_jps_generator.GenerateJPS(:2,:3), null) as Resume ,'Resume.htm' as FileName, from dual

Oracle Community | 884536 | 4 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

    How to stop OAFpage auto refresh

    Oracle Community | 5 years ago | 884536
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select nvl2(:1, irc_jps_generator.GenerateJPS(:2,:3), null) as Resume ,'Resume.htm' as FileName, from dual
  2. 0

    Statement Preparation Error in Stnadared OAF Page

    Oracle Community | 4 years ago | 884536
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select nvl2(:1, irc_jps_generator.GenerateJPS(:2,:3), null) as Resume ,'Resume.htm' as FileName, from dual
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 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

    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 nvl2(:1, irc_jps_generator.GenerateJPS(:2,:3), null) as Resume ,'Resume.htm' as FileName, from dual

      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. oracle.apps.per
      AplRegCreateResumeCO.processRequest
      1. oracle.apps.per.irc.candidateSelfService.webui.AplRegCreateResumeCO.processRequest(AplRegCreateResumeCO.java:48)
      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.OAHeaderBean.processRequest(OAHeaderBean.java:389)
      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.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      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.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      13. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      19. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      24. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      25. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2360)
      26. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1759)
      27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
      28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
      28 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:534)
      1 frame