java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PO"."PO_ATTRIBUTE_VALUES_TLP_DRAFT"."DESCRIPTION")

Oracle Community | 2996619 | 1 year ago
  1. 0

    while saving Blanket purchase Agreements in oaf page i am getting this error

    Oracle Community | 1 year ago | 2996619
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PO"."PO_ATTRIBUTE_VALUES_TLP_DRAFT"."DESCRIPTION")
  2. 0

    Oracle Access Manager default installation issue: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated

    Oracle Community | 2 years ago | Bram van Pelt
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated
  3. 0

    ODI Agent Failed

    Oracle Community | 7 months ago | Kimi
    oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access. ORA-01400: cannot insert NULL into ("EPMREP"."SNP_CONNECT_PROP"."PROP_KEY")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Active Directory Group Recon Error in OIM11gR2

    Oracle Community | 4 years ago | Srivatsa.kashyap
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("DEV_OIM"."UD_ADGRP"."UD_ADUSER_KEY")
  6. 0

    OIM Connector Installation Error

    Oracle Community | 3 years ago | 871346
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OIM.OIMHOME_JARS_UNIQUE) violated
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.SQLIntegrityConstraintViolationException

    ORA-01400: cannot insert NULL into ("PO"."PO_ATTRIBUTE_VALUES_TLP_DRAFT"."DESCRIPTION")

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeUpdate
    1. weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    1 frame
  4. oracle.jbo.server
    EntityImpl.doDML
    1. oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:427)
    2. oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5743)
    2 frames
  5. oracle.apps.po
    PoAttributeValuesTLPMergeEOImpl.doDML
    1. oracle.apps.po.schema.server.PoBaseEOImpl.doDML(PoBaseEOImpl.java:107)
    2. oracle.apps.po.schema.server.PoMergeBaseEOImpl.doDML(PoMergeBaseEOImpl.java:210)
    3. oracle.apps.po.schema.server.PoAttributeValuesTLPMergeEOImpl.doDML(PoAttributeValuesTLPMergeEOImpl.java:428)
    3 frames
  6. oracle.jbo.server
    EntityImpl.postChanges
    1. oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4542)
    1 frame
  7. oracle.apps.fnd
    OAEntityImpl.postChanges
    1. oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
    1 frame
  8. oracle.apps.po
    PoAttributeValuesTLPMergeEOImpl.postChanges
    1. oracle.apps.po.schema.server.PoMergeBaseEOImpl.postChanges(PoMergeBaseEOImpl.java:725)
    2. oracle.apps.po.schema.server.PoAttributeValuesTLPMergeEOImpl.postChanges(PoAttributeValuesTLPMergeEOImpl.java:486)
    2 frames
  9. oracle.jbo.server
    DBTransactionImpl.postChanges
    1. oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
    2. oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2815)
    3. oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2648)
    3 frames
  10. oracle.apps.po
    PoBaseAMImpl.executeServerCommand
    1. oracle.apps.po.document.server.PoHeaderSvrCmd.save(PoHeaderSvrCmd.java:2718)
    2. oracle.apps.po.document.server.PoHeaderSvrCmd.save(PoHeaderSvrCmd.java:2990)
    3. oracle.apps.po.document.server.PoHeaderSvrCmd.execute(PoHeaderSvrCmd.java:641)
    4. oracle.apps.po.common.server.PoBaseAMImpl.executeServerCommand(PoBaseAMImpl.java:110)
    4 frames
  11. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1575.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  12. oracle.apps.fnd
    OAApplicationModuleImpl.invokeMethod
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
    2. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:733)
    2 frames
  13. oracle.apps.po
    BlanketCO.processFormRequest
    1. oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
    2. oracle.apps.po.document.common.webui.DocumentCO.processAction(DocumentCO.java:1621)
    3. oracle.apps.po.document.common.webui.DocumentCO.processConvertCurrencyAndAction(DocumentCO.java:1356)
    4. oracle.apps.po.document.common.webui.DocumentCO.processFormRequest(DocumentCO.java:439)
    5. oracle.apps.po.document.agreement.webui.BlanketCO.processFormRequest(BlanketCO.java:77)
    5 frames
  14. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1319)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3169)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1924)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
    18 frames
  15. _pages
    __oa._jspService
    1. _pages.__oa._jspService(__oa.java:233)
    1 frame
  16. weblogic.servlet.jsp
    JspBase.service
    1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
    1 frame
  17. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    5 frames
  18. oracle.apps.fnd
    WLFilter.doFilter
    1. oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
    1 frame
  19. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  20. oracle.apps.jtf
    JTFWrapperFilter.doFilter
    1. oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
    1 frame
  21. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  22. oracle.apps.jtf
    ReleaseResFilter.doFilter
    1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
    1 frame
  23. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  24. oracle.apps.fnd
    AppsServletFilter.doFilter
    1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
    1 frame
  25. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  26. oracle.security.jps
    JpsAbsFilter$1.run
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    1 frame
  27. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  28. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
    2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
    3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    5 frames
  29. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    1 frame
  30. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
    1 frame
  31. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
    3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
    3 frames
  32. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  33. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  34. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
    3 frames
  35. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames