E1: 09: Work With Auto Bank Statement (P09616) Is Showing the Warning Message "Closing balance is incorrect" (ALIAS 09BAL), Even the Sum of Beginning Balance, Total Debits and Total Credits Does Add Up to the Closing Balance (Doc ID 3015596.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

When reviewing a bank statement in the P09616 Work With Auto Bank Statement application, a misleading warning message "Closing balance is incorrect" (Alias 09BAL) is being shown, despite the fact that the Sum of Beginning Balance, Total Debits and Total Credits equals the Closing Balance.

Steps:

1. Double check on the Swift file received from the bank, to be in accordance with the recommendations from the KM document E1: 09: Overview of Automatic Bank Statement Reconciliation (P09610/P09616/P09617/P09621/P09622/P09626/P09627/P09628/P09631/R09600/R09612/R09616) (Doc ID 2097234.2), see the Field Mapping tab, related to the Swift file format.
2. Go and place the file on the JDE 9.2 recommended Import/Export path.
3. Go to Batch Versions, set the Processing Options of the R09600 Process Automatic Bank Statements Flat File version, then run it, to transfer the data from the flat file to the staging tables (F09610 and F09611 tables).
4. Go to P09610 Work with Electronic Bank Statement Staging to check on the records loaded into the staging tables (F09610 and F09611 tables. Notice that no warning or error is being thrown!
5. Go to Batch Versions, set the Processing Options of the R09612 Load Bank Statement, then run it, to transfer the data from the staging tables (F09610 and F09611 tables) to the bank statement tables (F09616 and F09617 tables).
6. Go to P09616 Work With Auto Bank Statement to check on the bank statement transactions. Notice that the P09616 application is throwing the warning message “Closing balance is incorrect” (Alias 09BAL), warning message that is not correct, since the sum of Beginning Balance, Total Debits and Total Credits equals the Closing Balance.
   
   

Changes

Cause

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