ArrayIndexOutOfBoundsException On PRTY-ARS-COLL In PUPL Batch (Doc ID 2750991.1)

Last updated on JUNE 04, 2024

Applies to:

Symptoms

On : 2.5.0.2.0 version, UT - Utilities

Issue in PUPL Batch Job

After our initial analysis we believe the issue is arising from the Base PUPL code and it happens when the customer pays and the Ars amount FT query is fetching more than 130 records then the system gives array index out of bound exception. Below is the query which fetches the number of rows

SELECT FT.ARS_DT, SUM(CUR_AMT)
FROM CI_FT FT WHERE FT.SA_ID = '7000500602'
AND FT.REDUNDANT_SW = 'N' AND FT.CUR_AMT > 0
AND FT.FREEZE_SW = 'Y' AND FT.ARS_DT IS NOT NULL
AND (FT.ARS_DT BETWEEN to_date('1801-11-11','YYYY-MM-DD') AND to_date('2020-11-21','YYYY-MM-DD'))
AND (('N' = 'N' AND FT.NOT_IN_ARS_SW <> 'Y')
OR ('N' = 'Y'
AND (SUBSTR(FT.MATCH_EVT_ID,1,1) = ' '
OR FT.MATCH_EVT_ID IN (SELECT ME.MATCH_EVT_ID FROM CI_MATCH_EVT ME WHERE
ME.ACCT_ID = '7000500000' AND ME.DISPUTE_SW = 'N' AND ME.MEVT_STATUS_FLG = 'O' ) ) ) )
GROUP BY FT.ARS_DT ORDER BY FT.ARS_DT ;

If the values fetched from the query is more than 130 records then Array Index out of bound exception is thrown from the PUPL batch.

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.