CM: When Manually Updating the Available Balances in Enter Internal Bank Balances Page, the Interest Bearing Balances for Prior Dates Are Also Being Updated to Match the Available Balance, Resulting in History Data Discrepancies (Doc ID 3034237.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

When manually updating the available balances, the interest bearing balances for prior dates are also being updated to match the available balance, resulting in discrepancies between pre and post-update table data.

Steps:

   1. Generate Daily Schedule for period between 01/01/2001 and 12/31/2024 .

(Navigation:  Set Up Financials/Supply Chain > Product Related > Treasury > Generates Schedules)

   2. Create internal banks and establish internal bank account between them (used TUS01, TUS04 from DEMO).

(Navigation: Banking > Bank Accounts > Internal Accounts)

   3. Update internal bank account balance manually from enter internal bank balance pages:

(Navigation: Banking > Bank Statements > Enter Internal Bank Balances)

•  Set Stm Date/Opening Balance Date/Closing Date to 05/01/2024.
• Set Available Balance to -145,141,944.00

   4. Run the accrue interest process.

(Navigation: Cash Management > In House Banking > Calculate Interest Accruals)

   5. Again update available balance in enter internal bank balance page on 02 June:

•  Set Stm Date/Opening Balance Date/Closing Date to 06/02/2024.
•  Set Available Balance to -200,000.00

   6. Review data in BNK_BALANCE_TBL for I0024 and I0025 internal accounts by querying BNK_BALANCE_TBL in SQL Developer.

Results: When updating the available balance for a particular row, ideally int bearing balance for that row also get updated equivalent to available balance which is as expected but here even for all the other rows also int bearing balance is becoming equivalent to available balance of that corresponding row which can cause discrepancy in pre and post data'.

Cause

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