Payment Calls Are Failing with Query Timeout Exception (Doc ID 2975277.1)

Last updated on SEPTEMBER 28, 2023

Applies to:

Symptoms

On : 2.8.0.0.0 version, ENV - Environment

ACTUAL BEHAVIOR
---------------

Payment calls are failing with Query timeout exception.

Query Timeout Calling com.splwg.ccb.domain.financial.common.ProgramCIPFACCN_Impl SQL

Can this be analyzed and provide a fix to use fine tuned query?

SELECT SUM (FT.CUR_AMT)
  FROM CI_ACCT AC,
  CI_CUST_CL CC,
  CI_FT FT,
  CI_SA SA,
  CI_MATCH_EVT ME
 WHERE AC.ACCT_ID = :1
  AND CC.CUST_CL_CD = AC.CUST_CL_CD
  AND CC.OPEN_ITEM_SW = :"SYS_B_0"
  AND SA.ACCT_ID = AC.ACCT_ID
  AND FT.SA_ID = SA.SA_ID
  AND FT.CURRENCY_CD = :2
  AND FT.REDUNDANT_SW = :"SYS_B_1"
  AND FT.FREEZE_SW = :"SYS_B_2"
  AND SUBSTR (FT.MATCH_EVT_ID, :"SYS_B_3", :"SYS_B_4") <> :"SYS_B_5"
  AND ME.MATCH_EVT_ID = FT.MATCH_EVT_ID
  AND ME.DISPUTE_SW = :"SYS_B_6"
  AND ME.MEVT_STATUS_FLG = :"SYS_B_7" /* SQL for program 'com.splwg.ccb.domain.financial.common.ProgramCIPFACCN_Impl', SQL name 'S_ALLDISP' */

Changes

Cause

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