ECM 9.2: Accrue Interest Process (TR_TRINTACU) Is Not Calculating Interest Correctly For In-House Banking Bank Transfers. (Doc ID 3065640.1)

Last updated on JANUARY 06, 2025

Applies to:

Symptoms

When Bank transfer is performed between two internal bank accounts. After running the Accrue Interest Process, BNK_BALANCE_TBL is getting updated correctly for the credit account and debit account but except for day 1 of transaction. The interest on day 1 is calculated with credit margin points for the debit account.

Steps:
1. Create internal banks.
     Banking > Banks and Branches > Bank Information.
2. Setup schedule, Market Rate and Accounting template for interests.
     Set Up Financials/Supply Chain > Common Definitions > Calendars/Schedules > Create Schedules.
     Set Up Financials/Supply Chain > Common Definitions > Market Rates > Market Rate Definition.
     Set Up Financials/Supply Chain > Common Definitions > Market Rates > Market Rate Index.
     Set Up Financials/Supply Chain > Common Definitions > Market Rates > Market Rate Type.
     Cash Management > Treasury Accounting > Accounting Templates.
3. Create internal accounts between two banks define above and define the credit and debit margin points.
     Banking > Bank Accounts > Internal Accounts.
4. Create a bank account transfer.
     Cash Management > Fees and Transfers > Bank Account Transfer.
5. Run Accrue interest process(TR_TRINTACU).
6. Query the BNK_BALANCE_TBL to see the interest amount. Interest for credit bank is calculating using credit margin point and for debit bank using debit margin point on all days except the first day. On the day of the transaction, interest for debtor bank is calculating using credit margin point for day 1.

Cause

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