oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NtfAttribsEO.TEXT_VALUE, NtfAttribsEO.NOTIFICATION_ID, NtfAttribsEO.NAME, MsgAttribsEO.TYPE, MsgAttribsEO.MESSAGE_TYPE, MsgAttribsEO.MESSAGE_NAME, MsgAttribsEO.NAME AS NAME1, MsgAttribsEO.DISPLAY_NAME, MsgAttribsEO.FORMAT, NtfAttribsEO.NUMBER_VALUE, NtfAttribsEO.DATE_VALUE, MsgAttribsEO.SUBTYPE FROM WF_NOTIFICATIONS NtfEO, WF_NOTIFICATION_ATTRIBUTES NtfAttribsEO, WF_MESSAGE_ATTRIBUTES_VL MsgAttribsEO WHERE NtfEO.NOTIFICATION_ID = :1 AND NtfEO.NOTIFICATION_ID = NtfAttribsEO.NOTIFICATION_ID AND NtfEO.MESSAGE_TYPE = MsgAttribsEO.MESSAGE_TYPE AND NtfEO.MESSAGE_NAME = MsgAttribsEO.MESSAGE_NAME AND MsgAttribsEO.NAME = NtfAttribsEO.NAME ORDER BY length(MsgAttribsEO.NAME) desc

Oracle Community | Hanimi | 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

    java.sql.SQLException: ORA-01722: invalid number

    Oracle Community | 6 years ago | Hanimi
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NtfAttribsEO.TEXT_VALUE, NtfAttribsEO.NOTIFICATION_ID, NtfAttribsEO.NAME, MsgAttribsEO.TYPE, MsgAttribsEO.MESSAGE_TYPE, MsgAttribsEO.MESSAGE_NAME, MsgAttribsEO.NAME AS NAME1, MsgAttribsEO.DISPLAY_NAME, MsgAttribsEO.FORMAT, NtfAttribsEO.NUMBER_VALUE, NtfAttribsEO.DATE_VALUE, MsgAttribsEO.SUBTYPE FROM WF_NOTIFICATIONS NtfEO, WF_NOTIFICATION_ATTRIBUTES NtfAttribsEO, WF_MESSAGE_ATTRIBUTES_VL MsgAttribsEO WHERE NtfEO.NOTIFICATION_ID = :1 AND NtfEO.NOTIFICATION_ID = NtfAttribsEO.NOTIFICATION_ID AND NtfEO.MESSAGE_TYPE = MsgAttribsEO.MESSAGE_TYPE AND NtfEO.MESSAGE_NAME = MsgAttribsEO.MESSAGE_NAME AND MsgAttribsEO.NAME = NtfAttribsEO.NAME ORDER BY length(MsgAttribsEO.NAME) desc
  2. 0

    FND-INVALID APPLICATION in 11.5.10 Linux

    Oracle Community | 1 decade ago | 24803
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = fnd; (Could not lookup message because there is no database connection)
  3. 0

    JBO-25002 Definition oracle.apps.icx.por.wf.server.ReqApprovalNotifications

    Oracle Community | 1 decade ago | 523448
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.icx.por.wf.server.ReqApprovalNotificationsAM of type ApplicationModule not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Deployment Issue

    Oracle Community | 1 decade ago | 550167
    oracle.apps.fnd.framework.OAException: No data found for region (bmcs/oracle/apps/pqh/selfservice/common/webui/BmcsEffectiveDatePG).
  6. 0

    oracle.adf.mds.MetadataDefException------------No data found for region

    Oracle Community | 1 decade ago | 550167
    oracle.apps.fnd.framework.OAException: No data found for region (bmcs/oracle/apps/pqh/selfservice/common/webui/BmcsEffectiveDatePG).

    11 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 NtfAttribsEO.TEXT_VALUE, NtfAttribsEO.NOTIFICATION_ID, NtfAttribsEO.NAME, MsgAttribsEO.TYPE, MsgAttribsEO.MESSAGE_TYPE, MsgAttribsEO.MESSAGE_NAME, MsgAttribsEO.NAME AS NAME1, MsgAttribsEO.DISPLAY_NAME, MsgAttribsEO.FORMAT, NtfAttribsEO.NUMBER_VALUE, NtfAttribsEO.DATE_VALUE, MsgAttribsEO.SUBTYPE FROM WF_NOTIFICATIONS NtfEO, WF_NOTIFICATION_ATTRIBUTES NtfAttribsEO, WF_MESSAGE_ATTRIBUTES_VL MsgAttribsEO WHERE NtfEO.NOTIFICATION_ID = :1 AND NtfEO.NOTIFICATION_ID = NtfAttribsEO.NOTIFICATION_ID AND NtfEO.MESSAGE_TYPE = MsgAttribsEO.MESSAGE_TYPE AND NtfEO.MESSAGE_NAME = MsgAttribsEO.MESSAGE_NAME AND MsgAttribsEO.NAME = NtfAttribsEO.NAME ORDER BY length(MsgAttribsEO.NAME) desc

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:210)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:152)
      6. oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1086)
      7. oracle.apps.fnd.wf.worklist.server.WorklistAMImpl.initializeWebValues(WorklistAMImpl.java:106)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.initializeWebValues(OAWebBeanContainerHelper.java:527)
      9. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2110)
      10. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1711)
      11. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
      12. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
      12 frames
    3. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:88)
      1 frame
    4. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    5. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    6. 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
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    8. oracle.jsp.provider
      Jsp20RequestDispatcher.forward
      1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
      1 frame
    9. oracle.jsp.runtime
      OraclePageContext.forward
      1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
      1 frame
    10. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:98)
      1 frame
    11. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    12. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    13. 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
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    15. oracle.jsp.provider
      Jsp20RequestDispatcher.forward
      1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
      1 frame
    16. oracle.jsp.runtime
      OraclePageContext.forward
      1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
      1 frame
    17. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:98)
      1 frame
    18. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    19. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    20. 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
    21. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    22. 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
    23. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame