My Oracle Support Banner

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

Last updated on SEPTEMBER 02, 2021

Applies to:

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

Symptoms

On : 2.8.0.0.0 version, SW - System Wide

ACTUAL BEHAVIOR
---------------
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).

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
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.