java.sql.SQLException: ORA-01400: cannot insert NULL into ("XXPMC"."XXPMC_ORDER_HEADER_NOTES"."HEADER_ID")

Oracle Community | Mini | 5 years ago
  1. 0

    oracle.jbo.DMLException: JBO-26041: Failed to post data

    Oracle Community | 5 years ago | Mini
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("XXPMC"."XXPMC_ORDER_HEADER_NOTES"."HEADER_ID")
  2. 0

    Urgent Help (Insert Jdev10.1.3.3.0)

    Oracle Community | 8 years ago | 660764
    java.sql.SQLException: ORA-00911: invalid character
  3. 0

    WhO column error in OAF page

    Oracle Community | 8 years ago | user9952568
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("APPS"."TEST_EMP"."LAST_UPDATED_BY")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JBO-26041: Failed to post data to database during "Insert": SQL Statement "

    Oracle Community | 7 years ago | 659788
    java.sql.SQLException: ORA-00911: invalid character
  6. 0

    Facing problem in inserting record into table

    Oracle Community | 9 years ago | 603889
    java.sql.SQLException: ORA-00911: invalid character

    4 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-01400: cannot insert NULL into ("XXPMC"."XXPMC_ORDER_HEADER_NOTES"."HEADER_ID")

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeUpdate
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
      6. oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
      8. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      9. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3074)
      9 frames
    3. oracle.jbo.server
      EntityImpl.postChanges
      1. oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:427)
      2. oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5740)
      3. oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4539)
      3 frames
    4. oracle.apps.fnd
      OAEntityImpl.postChanges
      1. oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(Unknown Source)
      1 frame
    5. oracle.jbo.server
      DBTransactionImpl.commit
      1. oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996)
      2. oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807)
      3. oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1971)
      4. oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173)
      4 frames
    6. oracle.apps.fnd
      OADBTransactionImpl.commit
      1. oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(Unknown Source)
      1 frame
    7. testinsert.oracle.apps
      MainAMImpl.apply
      1. testinsert.oracle.apps.ont.server.MainAMImpl.apply(MainAMImpl.java:40)
      1 frame
    8. 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:585)
      4 frames
    9. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
      2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
      3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(Unknown Source)
      3 frames
    10. testinsert.oracle.apps
      MyCO.processFormRequest
      1. testinsert.oracle.apps.ont.webui.MyCO.processFormRequest(MyCO.java:46)
      1 frame