oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO XXCUR_TRADE_CUSTOMER_DETAILS_D(CUSTOMER_ID,CONSOLIDATION_LEVEL,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE) VALUES (?,?,?,?,?,?,?) RETURNING ROWID INTO ?; END;".

Oracle Community | OliverM-Oracle | 5 years ago
  1. 0

    custom DB Table in xxcurrnx schema

    Oracle Community | 5 years ago | OliverM-Oracle
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO XXCUR_TRADE_CUSTOMER_DETAILS_D(CUSTOMER_ID,CONSOLIDATION_LEVEL,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE) VALUES (?,?,?,?,?,?,?) RETURNING ROWID INTO ?; END;".
  2. 0

    db:: 4.74::DirectAccess Services operation status is unknown a1

    hivmr.com | 5 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "UK1" violated during post operation:"Insert" using SQL Statement "BEGIN INSERT INTO COM_TOE_HEADER(TOE_HEADER_ID,TOE_NUMBER,EFFECTIVE_DATE,EM_HEADER_ID,TOE_TYPE_HEADER_ID,APPROVED,STATUS,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) RETURNING APPROVED, STATUS INTO ?, ?; END;".
  3. 0

    DMLConstraintException

    Oracle Community | 6 years ago | Aamir Mughal
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "UK1" violated during post operation:"Insert" using SQL Statement "BEGIN INSERT INTO COM_TOE_HEADER(TOE_HEADER_ID,TOE_NUMBER,EFFECTIVE_DATE,EM_HEADER_ID,TOE_TYPE_HEADER_ID,APPROVED,STATUS,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) RETURNING APPROVED, STATUS INTO ?, ?; END;".
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Exception while accessing the DB Custom table

    Oracle Community | 5 years ago | 868733
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO XXCUR_TRADE_CUSTOMER_DETAILS(CUSTOMER_ID,BILLING_FREQUENCY,CONSOLIDATION_LEVEL,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE) VALUES (?,?,?,?,?,?,?,?) RETURNING ROWID INTO ?; END;".
  6. 0

    Unable to insert data into the table

    Oracle Community | 5 years ago | 683984
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO XXADT_TRG_COURSE_REQUIREMENTS(COURSE_REQUIREMENT_ID,COURSE_PROGRAM_ID,REQUIREMENT_NAME,SELECTED,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATED_BY,CREATION_DATE) VALUES (?,?,?,?,?,?,?,?,?)".

    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.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO XXCUR_TRADE_CUSTOMER_DETAILS_D(CUSTOMER_ID,CONSOLIDATION_LEVEL,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE) VALUES (?,?,?,?,?,?,?) RETURNING ROWID INTO ?; END;".

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OADBTransactionImpl.commit
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(Unknown Source)
      2 frames
    3. xxcurrnx.oracle.apps
      XxcurnxcustdtlsAMImpl.saveTransaction
      1. xxcurrnx.oracle.apps.ont.custdtls.server.XxcurnxcustdtlsAMImpl.saveTransaction(XxcurnxcustdtlsAMImpl.java:51)
      1 frame