ArrayIndexOutOfBoundsException On PRTY-ARS-COLL In PUPL Batch
(Doc ID 2750991.1)
Last updated on OCTOBER 04, 2022
Oracle Utilities Customer Care and Billing - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 2.5 to 2.6] Information in this document applies to any platform.
On : 184.108.40.206.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!