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)".

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by frsofiane, 1 year ago
,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 413724, 6 months ago
JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO SITE_TARIFF_ITEM(SITE_TARIFF_ITEM_ID,SITE_ID,SITE_TARIFF_ID,SITE_ITEM_ID,QTY,QTY_PRICE,STATUS,IS_LOCKED,T_MODIFIED) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9
via Oracle Community by 429558, 10 months ago
JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO IAC_TASKING_IN FO(TASKING_NAME,TASKING_MEMO_NUMBER,TASKING_INFO_ID,ACTION_OFFICER_ID,MODULE_ID, DELETE_FLAG,TASK_DATADATE) VALUES (:1,:2,:3,:4,:5,:6 ,:7) RETURNING DELETE_FLAG INTO :8; END;".
via Oracle Community by 411857, 10 months ago
JBO-26041: Kan geen gegevens naar database versturen tijdens "Invoegen": SQL-statement "BEGIN INSERT INTO DUS_V_TIMESHEET_STATUSSEN(ID,OMSCHRIJVING) VALUES (?,?);SELECT ID INTO ? FROM DUS_V_TIMESHEET_STATUSSEN WHERE ID=?; END;".
via Oracle Community by 68375, 1 year ago
JBO-26041: Failed to post data to database during "Update": SQL Statement " UPDATE APPLICATIONSTEMP.BCDATA Bcdata SET NCLOBDATA=:1 WHERE ID=:2".
via Oracle Community by 404001, 10 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)".
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)
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.