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

Oracle Community | Govindan | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    You have encountered an unexpected error. Please contact the System Adminis

    Oracle Community | 5 years ago | Govindan
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO PA_INTEGRATION_CONTROLS(OPERATING_UNIT,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,INTEGRATION_OPTION_NAME) VALUES (:1,:2,:3,:4,:5,:6,:7) RETURNING ROWID INTO :8; END;".
  2. 0

    Updating database values using entity object

    Oracle Community | 1 decade ago | 539128
    oracle.apps.fnd.framework.OAException: java.lang.IndexOutOfBoundsException: Index: 9, Size: 9
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    java.lang.ArrayIndexOutOfBoundsException when retainAM is set to true

    Oracle Community | 9 years ago | 581840
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 2
  5. 0

    error page : please contact system administrator

    Oracle Community | 6 years ago | 760019
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at ""SYS.HTP"", line 1469 ORA-06512: at ""SYS.HTP"", line 1689 ORA-06512: at ""APPS.ORACLEAPPS"", line 1111 ORA-06502: PL/SQL: numeric or value error ORA-06512: at ""APPS.ICX_SEC"", line 3111 ORA-06502: PL/SQL: numeric or value error ORA-06512: at ""SYS.OWA_UTIL"", line 325 ORA-06512: at ""SYS.HTP"", line 1322 ORA-06512: at ""SYS.HTP"", line 1397 ORA-06512: at ""SYS.HTP"", line 1689 ORA-06512: at ""APPS.ICX_SEC"", line 3457 ORA-06502: PL/SQL: numeric or value error ORA-06512: at ""APPS.HR_UTIL_DISP_WEB"", line 3518 ORA-06512: at ""APPS.HR_DYNAMIC_APPROVAL_WEB"", line 3644 ORA-01436: CONNECT BY loop in user data ORA-06512: at ""APPS.HR_DYNAMIC_APPROVAL_WEB"", line 7743 ORA-06512: at line 1 ;

    2 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. oracle.apps.fnd.framework.OAException

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

      at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:972)
      2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:210)
      3. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:132)
      4. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:756)
      4 frames
    3. oracle.apps.pa
      PaEditIntegrationOptionsCO.processFormRequest
      1. oracle.apps.pa.integration.webui.PaEditIntegrationOptionsCO.processFormRequest(PaEditIntegrationOptionsCO.java:193)
      1 frame
    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
    5. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:88)
      1 frame
    6. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    7. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    8. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    10. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame