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

Oracle Community | Debanjan Banerjee | 3 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

    SQL Error while VO.executequery()

    Oracle Community | 3 years ago | Debanjan Banerjee
    java.sql.SQLException: ORA-01843: not a valid month
  2. 0

    Error in Extending VO Object

    Oracle Community | 6 years ago | user12280967
    java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got DATE
  3. 0

    JBO-27122: Error when Embeding Custom Region

    Oracle Community | 5 years ago | CSK
    java.sql.SQLException: ORA-00904: "REPORTHEADERID": invalid identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error for a custom OAF page

    Oracle Community | 4 years ago | user2626293
    java.sql.SQLException: ORA-01722: invalid number
  6. 0

    DBLink in VO Query

    Oracle Community | 4 years ago | nancy25
    java.sql.SQLException: ORA-02019: connection description for remote database not found.

  1. rp 1 times, last 3 months ago
26 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. java.sql.SQLException

    ORA-01843: not a valid month

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2566)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)
    4 frames
  5. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:631)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:518)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3375)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828)
    4 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4525)
    1 frame
  7. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
    3. oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
    4. oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3339)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3326)
    5 frames
  8. oracle.apps.fnd
    OAViewObjectImpl.executeQuery
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
    1 frame
  9. WW.oracle.apps
    XXFieldCountAMImpl.GoBttn
    1. WW.oracle.apps.inv.fldcount.server.XXFieldCountAMImpl.GoBttn(XXFieldCountAMImpl.java:162)
    1 frame
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:324)
    4 frames
  11. oracle.apps.fnd
    OAApplicationModuleImpl.invokeMethod
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
    2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
    3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:785)
    3 frames
  12. WW.oracle.apps
    XXFieldCountCO.processFormRequest
    1. WW.oracle.apps.inv.fldcount.webui.XXFieldCountCO.processFormRequest(XXFieldCountCO.java:52)
    1 frame
  13. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:810)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1159)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2700)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
    18 frames
  14. _oa__html
    _OA._jspService
    1. _oa__html._OA._jspService(_OA.java:84)
    1 frame
  15. oracle.jsp.runtime
    HttpJsp.service
    1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
    1 frame
  16. oracle.jsp.app
    JspApplication.dispatchRequest
    1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
    1 frame
  17. 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
  18. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
    1 frame
  19. 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
  20. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:534)
    1 frame