My Oracle Support Banner

Price Assignment Upload through File Request Type is Giving ORA-01461 Error. (Doc ID 2670819.1)

Last updated on JANUARY 10, 2023

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.8.0.0.0 version

Price Assignment through XML upload is failing and showing below error in batch logs:
ORA-01461: can bind a LONG value only for insert into a LONG column

In threadpoolworker logs is showing below warning:
"WARN (support.sql.PreparedStatementImpl) The statement select price_parm_cd, price_parm_val from ci_priceasgn_parm where price_asgn_id = '1840002076' was already used- should be marked as autoclose(false) to be optimially reused"

ERROR
-----------------------
ORA-01461: can bind a LONG value only for insert into a LONG column

Cause

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
Symptoms
Cause
Solution
References


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