My Oracle Support Banner

Account Reconciliation Cloud Services (ARCS) Data Load Error "ORA-01461: Can Bind A LONG Value Only For Insert Into A LONG Column" (Doc ID 2275140.1)

Last updated on OCTOBER 29, 2018

Applies to:

Oracle Account Reconciliation Cloud Service - Version 16.03.53 to 16.10.47 [Release 16.0]
Information in this document applies to any platform.
Issue only happens to ARCS that is installed and upgraded from versions 16.11 and earlier.
New installation of ARCS 16.12 and higher is without this issue.


You are attempting to load data in Account Reconciliation Cloud Services (ARCS) using a CSV file but the following error occurs.

Exception SQLException has occurred after the invocation of method:
arm.model.applicationModule.DataloadAMImpl.importPreMappedBalances() [line:1065]
ORA-01461: can bind a LONG value only for insert into a LONG column


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.