My Oracle Support Banner

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

Last updated on FEBRUARY 09, 2021

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.5.0.2.0 and later
Information in this document applies to any platform.

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

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.