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 JUNE 12, 2017

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.

Symptoms

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

ERROR
-----------------------
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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms