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, :4 as RESUME_STYLE from dual

Oracle Community | Srini-999 | 5 years ago
  1. 0

    iRecruitment page erorr it's urgent.

    Oracle Community | 5 years ago | Srini-999
    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, :4 as RESUME_STYLE from dual
  2. 0

    self service page error in 12.0.5

    Oracle Community | 8 years ago | 683594
    oracle.apps.fnd.framework.OAException: java.lang.NumberFormatException: null
  3. 0

    Regd SPEL and VO extn

    Oracle Community | 7 years ago | 600702
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: cisco.oracle.apps.per.selfservice.mgrviews.server.XxchrEmployeeDetailsVOImpl
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error while terminating a 'Payment Process Request' in R12.

    Oracle Community | 4 years ago | rg3
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT r.calling_app_id, r.created_by, r.payment_service_request_id, r.creation_date, r.call_app_pay_service_req_code, fa.application_name, fu.user_name, r.payment_service_request_status FROM iby_pay_service_requests r, fnd_application_vl fa, fnd_user fu WHERE r.payment_service_request_id = :1 AND r.calling_app_id = fa.application_id(+) AND r.created_by = fu.user_id(+)
  6. 0

    oracle.apps.per.selfservices.appraisals.server.AppraisalVO

    Oracle Community | 4 years ago | OliverM-Oracle
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    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, :4 as RESUME_STYLE from dual

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993)
      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:762)
      6 frames
    3. oracle.apps.irc
      AplRegCreateResumeCO.processRequest
      1. oracle.apps.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:596)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      13. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      19. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      24. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      25. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513)
      26. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1894)
      27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538)
      28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)
      28 frames