ECM: Transaction By Account Page Not Showing Total Transaction Amount Correcttly, Not considering -ive and +ive Amounts

(Doc ID 2368884.1)

Last updated on MARCH 04, 2018

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Total Transaction Amount is not showing correct Amount on 'Transactions by Account' Page. When transactions are available for -ive and +ive Amounts only +ive amounts are considered for calculation for Total Transaction Amount and -ive amounts are ignored.

Steps:

1 a) Navigate : Banking > Analyze Exceptions >Transactions by Account
         - Provide External Bank ID, Account #, Date From and To, Status = UNR
         - Method = Check
   b) Click on Search Button
        - 1 Row Fetched for Negative Amount = -100 But Total Transaction Amount = 0
2 a) Navigate : Banking > Analyze Exceptions > Transactions by Account
        - Provide External Bank ID, Account #, Date From and To, Status = UNR
        - Method = Blank
   b) Click on Search Button
        - 3 Rows Fetched for Negative Amount(-375, -100, 200) But Total Transaction Amount = 200

Actual Behavior
Total Transaction Amount is not showing correct Amount on 'Transactions by Account' Page only considering +ive Amounts for calculation

Expected Behavior
Total Transaction Amount should show final amount after evaluating both +ive and -ive Amounts of the Transactions

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms