My Oracle Support Banner

t2t_FCT_CUST_REVIEW_REASONS failed with ORA-01489: result of string concatenation is too long (Doc ID 2621072.1)

Last updated on DECEMBER 17, 2019

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7 version

ACTUAL BEHAVIOR
---------------
The KYC task (t2t_FCT_CUST_REVIEW_REASONS) for the day is failed with the following error after enabling the change log. Kindly look into the issue and help us in this regard.

ORA-01489: result of string concatenation is too long

and culprit statement in the log is.

select RTI_ASSMNT_EVAL_EXPORT_DATA.n_Entity_Seq_Id,
  RTI_ASSMNT_EVAL_EXPORT_DATA.V_BATCH_RUN_ID,
  RTI_ASSMNT_EVAL_EXPORT_DATA.N_ASSMT_ID,
  RTI_ASSMNT_EVAL_EXPORT_DATA.N_EVAL_ID,
  ListAGG(RTI_ASSMNT_EVAL_EXPORT_DATA.V_EXPORT_DATA, ',') within group(order by RTI_ASSMNT_EVAL_EXPORT_DATA.V_EXPORT_DATA) as V_PARAM_RULE_ACTUAL_VALUE
  from RTI_ASSMNT_EVAL_EXPORT_DATA
  where RTI_ASSMNT_EVAL_EXPORT_DATA.V_BATCH_RUN_ID =
  (SELECT KDD_EXTRL_BATCH_LAST_RUN.BATCH_RUN_ID
  FROM KDD_EXTRL_BATCH_LAST_RUN
  WHERE KDD_EXTRL_BATCH_LAST_RUN.APP_ID = 'OFS_KYC')
  AND RTI_ASSMNT_EVAL_EXPORT_DATA.v_App_Id = 'OFS_KYC'
  group by RTI_ASSMNT_EVAL_EXPORT_DATA.n_Entity_Seq_Id,
  RTI_ASSMNT_EVAL_EXPORT_DATA.V_BATCH_RUN_ID,
  RTI_ASSMNT_EVAL_EXPORT_DATA.N_ASSMT_ID,
  RTI_ASSMNT_EVAL_EXPORT_DATA.N_EVAL_ID

.

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.