My Oracle Support Banner

Customer Support - Agent Dashboard Copy Service Request Fails with Error: 'java.sql.SQLException: ORA-01489'. (Doc ID 3038481.1)

Last updated on JULY 31, 2024

Applies to:

Oracle Customer Support - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When attempting to copy service request,
the following error occurs.

ERROR
-----------------------
The error message says 'java.sql.SQLException: ORA-01489: result of string concatenation is too long'
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT /*+ opt_param('_optimizer_cost_based_transformation' 'off') */ data_type, log_date date1,


STEPS
-----------------------
1. Customer Support Specialist->Agent Dashboard
2. Query SR and copy > Apply
3. There is some concatenation issue. Error on page.
4. Remove any one attribute and save, page saves without error.

Changes

 

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
Changes
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.