oracle.jbo.DMLException

JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO AM_AMORT_PROFILES(APR_GRP_ID,APR_CMP_ID,APR_CODE,APR_ID,APR_IFA_CODE,APR_DESCRIPTION_LOC,APR_DESCRIPTION_ETR,APR_DEV_ID,APR_DEVISE_TAUX,APR_VALEUR_ACQUIS,APR_VALEUR_ACQUIS_LC,APR_VALEUR_RESIDUELLE,APR_VALEUR_RESIDUELLE_LC,APR_DATE_ACQUIS,APR_DATE_SERVICE,APR_QUANTITE,APR_FOURNISSEUR_CODE,APR_FOURNISSEUR_LOC,APR_BAT_ID,APR_BUR_ID,APR_ETA_ID,APR_TYPE,APR_AMORT_MODE,APR_AMORT_DUREE_AN,APR_AMORT_DUREE_MOIS,APR_AMORT_DATE_DEPART,APR_AMORT_PRORATA,APR_VALEUR_AMORT_JOURS,APR_VALEUR_AMORT_JOURS_LC,APR_COMPTE_IMO,APR_COMPTE_ECO,APR_COMPTE_DOT,APR_COMPTE_VCT,APR_COMPTE_CCS,APR_COMPTE_PCS,APR_COMPTE_TVA,APR_ACTIVE_FLAG,APR_VALIDE_FLAG,APR_CREER_PAR,APR_CREER_DATE,APR_VALEUR_AMORT_MOIS,APR_VALEUR_AMORT_MOIS_LC,APR_STATU) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43)".

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web179

  • ,APR_VALEUR_AMORT_MOIS,APR_VALEUR_AMORT_MOIS_LC,APR_STATU) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43)".
  • via Oracle Community by 3004, 1 year ago
    ,ACTIVIDAD_MADRE,ACTTIPO,PROYFASE,ACTFESPINI,ACTFE SPFIN) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17) RETUR NING PROYECTO, ACTIVIDAD, RESPONSABLE, ACTDESCRIPCION, ACTESTADO, ACTFPREVINI, A CTFPREVFIN, ACTAVANCE, ACTFREALINI
  • via Oracle Community by 404001, 4 months ago
    ,CHECKED_BY,DEDU_METHOD,CHG_METHOD_DATE,CHG_METHOD_BY,PAY_SITE,CHG_SITE_DATE,CHG_SITE_BY,NOTES,REF_ID,REF_SYS_ID,REF_DATE,CREATE_BY,CREATE_DATE,UPDATE_BY,UPDATE_DATE,REF_OLD_TID) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29)".
  • Stack trace

    • oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO AM_AMORT_PROFILES(APR_GRP_ID,APR_CMP_ID,APR_CODE,APR_ID,APR_IFA_CODE,APR_DESCRIPTION_LOC,APR_DESCRIPTION_ETR,APR_DEV_ID,APR_DEVISE_TAUX,APR_VALEUR_ACQUIS,APR_VALEUR_ACQUIS_LC,APR_VALEUR_RESIDUELLE,APR_VALEUR_RESIDUELLE_LC,APR_DATE_ACQUIS,APR_DATE_SERVICE,APR_QUANTITE,APR_FOURNISSEUR_CODE,APR_FOURNISSEUR_LOC,APR_BAT_ID,APR_BUR_ID,APR_ETA_ID,APR_TYPE,APR_AMORT_MODE,APR_AMORT_DUREE_AN,APR_AMORT_DUREE_MOIS,APR_AMORT_DATE_DEPART,APR_AMORT_PRORATA,APR_VALEUR_AMORT_JOURS,APR_VALEUR_AMORT_JOURS_LC,APR_COMPTE_IMO,APR_COMPTE_ECO,APR_COMPTE_DOT,APR_COMPTE_VCT,APR_COMPTE_CCS,APR_COMPTE_PCS,APR_COMPTE_TVA,APR_ACTIVE_FLAG,APR_VALIDE_FLAG,APR_CREER_PAR,APR_CREER_DATE,APR_VALEUR_AMORT_MOIS,APR_VALEUR_AMORT_MOIS_LC,APR_STATU) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43)". at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:581) at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:8494) at Immoblisation.model.AmAmortProfilesImpl.doDML(AmAmortProfilesImpl.java:1699) at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:6751) at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3264) at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:3067) at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2071) at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2352) at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1590) at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1415) at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1428) at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169) at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731) at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193) at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412) at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112) at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6289) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6054) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4652) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4482) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4482) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:603) at java.awt.EventQueue$1.run(EventQueue.java:601) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:617) at java.awt.EventQueue$2.run(EventQueue.java:615) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:614) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.sql.SQLException: Invalid column type at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:11169) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:10518) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:11574) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:11544) at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:249) at oracle.jbo.server.OracleSQLBuilderImpl.bindInsertStatement(OracleSQLBuilderImpl.java:2033) at oracle.jbo.server.EntityImpl.bindDMLStatement(EntityImpl.java:10424) at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:415) ... 53 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    5 more bugmates