Error Importing Transactions
My Users are getting the error at the bottom of this page while importing transactions to a reconciliation. The load file is immediately below.
LOAD FILE:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Transaction Code,Description,Open Date,Close Date,Amount1
WARPROVJAN,Warranty Provision,31-Jan-14,,-99999.00
WARCOSTJAN,Warranty costs reclassed,31-Jan-14,,77777.00
ERROR:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
JBO-26041:
Failed to post data to database during "Insert": SQL Statement
"INSERT INTO
ARM_TRANSACTIONS(TRANSACTION_ID,TRANSACTION_CODE,TRANSACTION_DESCRIPTION,TRANSACTION_TYPE,RECONCILIATION_ID,OPEN_DATE,AGE,STATUS_FLAG,SUMMARY_CREATED,OBJECT_VERSION_NUMBER,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATED_BY,CREATION_DATE)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)".
JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO ARM_TRANSACTIONS(TRANSACTION_ID,TRANSACTION_CODE,TRANSACTION_DESCRIPTION,TRANSACTION_TYPE,RECONCILIATION_ID,OPEN_DATE,AGE,STATUS_FLAG,SUMMARY_CREATED,OBJECT_VERSION_NUMBER,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATED_BY,CREATION_DATE) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)".