oracle.apps.fnd.framework.OAException: java.sql.SQLDataException: ORA-01801: date format is too long for internal buffer ORA-06512: at "APPS.PA_SCHEDULE_PUB", line 434 ORA-06512: at line 1at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

Oracle Community | 943958 | 4 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    ORA-01801: date format is too long for internal buffer

    Oracle Community | 4 years ago | 943958
    oracle.apps.fnd.framework.OAException: java.sql.SQLDataException: ORA-01801: date format is too long for internal buffer ORA-06512: at "APPS.PA_SCHEDULE_PUB", line 434 ORA-06512: at line 1at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      java.sql.SQLDataException: ORA-01801: date format is too long for internal buffer ORA-06512: at "APPS.PA_SCHEDULE_PUB", line 434 ORA-06512: at line 1at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

      at oracle.apps.pa.schedule.server.UpdateScheduleVORowImpl.updateRow()
    2. oracle.apps.pa
      UpdateScheduleVORowImpl.updateRow
      1. oracle.apps.pa.schedule.server.UpdateScheduleVORowImpl.updateRow(UpdateScheduleVORowImpl.java:667)
      1 frame
    3. oracle.apps.fnd
      OAPlsqlViewObjectImpl.beforeCommit
      1. oracle.apps.fnd.framework.server.OAPlsqlViewRowImpl.callAPI(OAPlsqlViewRowImpl.java:111)
      2. oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.callAPI(OAPlsqlViewObjectImpl.java:163)
      3. oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.beforeCommit(OAPlsqlViewObjectImpl.java:430)
      3 frames
    4. oracle.jbo.server
      DBTransactionImpl.commit
      1. oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2009)
      2. oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173)
      2 frames
    5. oracle.apps.fnd
      OADBTransactionImpl.commit
      1. oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:690)
      1 frame
    6. oracle.apps.pa
      UpdateScheduleTopCO.processFormRequest
      1. oracle.apps.pa.schedule.webui.UpdateScheduleTopCO.processFormRequest(UpdateScheduleTopCO.java:693)
      1 frame
    7. XXX.oracle.apps
      XXXXPAUpdateScheduleTopCO.processFormRequest
      1. XXX.oracle.apps.pa.schedule.webui.XXXXPAUpdateScheduleTopCO.processFormRequest(XXXXPAUpdateScheduleTopCO.java:1512)
      1 frame
    8. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:827)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:860)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:860)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      13. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1205)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:860)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      19. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:860)
      23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      24. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      25. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2996)
      26. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1884)
      27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:549)
      28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:437)
      28 frames