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