oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO COLLEGE(CID,CNAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7) RETURNING ROWID INTO :8; END;".

Oracle Community | 868733 | 5 years ago
  1. 0

    Exception while inserting the data into 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 COLLEGE(CID,CNAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7) RETURNING ROWID INTO :8; END;".
  2. 0

    its urgent:how to insert data already table having data

    Oracle Community | 5 years ago | 901162
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement " INSERT INTO APPSOTH.WNS_PROJECT_ORGANIZATION_DTL(PROJ_NUMBER,HORIZONTAL_INTERNAL,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) VALUES (:1,:2,:3,:4,:5,:6,:7)".
  3. 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;".
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Urgent: Getting a oracle.jbo.DMLException: JBO-26041

    Oracle Community | 1 decade ago | 459203
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement " INSERT INTO GECM_SUBCOM_CATEGORIES_MAP(CATEGORY_KEY_ID,SUB_COMMODITY_ID,CATEGORY_ID,LAST_UPDATED_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7)".; (Could not lookup message because there is no database connection)
  6. 0

    Facing problem in inserting record into table

    Oracle Community | 9 years ago | 603889
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO MISIBE_NOLICENSEREPORT(ID,PARTY_ID,REPORT_DATE,CREATED_BY) 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 COLLEGE(CID,CNAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7) RETURNING ROWID INTO :8; END;".

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OADBTransactionImpl.commit
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
      2. oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:701)
      2 frames
    3. xxcrnx.oracle.apps
      XxcustconsetupcreaCO.processFormRequest
      1. xxcrnx.oracle.apps.ont.custrlines.server.XxcrnxAMImpl.saveTransaction(XxcrnxAMImpl.java:47)
      2. xxcrnx.oracle.apps.ont.custrlines.webui.XxcustconsetupcreaCO.processFormRequest(XxcustconsetupcreaCO.java:50)
      2 frames
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:799)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1118)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
      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:995)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
      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:2633)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
      18 frames