My Oracle Support Banner

WXFinancialHistoryRetriever IWS Is Giving Incorrect Payment Amount (Doc ID 2795817.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Oracle Utilities Customer Care and Billing - Version to [Release 2.8]
Information in this document applies to any platform.


On : version, SW - System Wide

WXFinancialHistoryRetriever IWS is giving incorrect payment amount

The Account made 2 payments of $100 on 7/2/2021. Each payment is consist of multiple FTs. Total payment made that day is only $200. When WXFinancialHistoryRetriever is called, it returned an incorrect payment amount of $700 for 7/2/2021. This should only be 200.

Upon investigation, it looks like Zone C1-ACCTFNHS SQL Statement 5 is changed from 2.4 version and is now summing up the PAY_AMT based on the number of FTs. This is not correct. Either the amount to be summed up should be the FT amount or the FT table should be removed from the SQL(same with 2.4).


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

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