IC Overdraft Interest Rates Are Incorrect After Base Rate Change (Doc ID 2883934.1)

Last updated on JULY 25, 2022

Applies to:

Symptoms

On : 14.5.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
IC Overdraft interest Rates are incorrect after Base Rate change

IC resolved value not considering maintained Spread/Margin when Base Rate/Float Rate is changed

EXPECTED BEHAVIOR
-----------------------
IC resolved value should consider maintained Spread/Margin when Base Rate/Float Rate is changed
System should keep Margin Rates whenever Base Rate is updated and calculte resolved value as the sum of Base Rate value + Margin Rate.

STEPS:
---------------------
1.Account is created with special condition
2.Account is associated with a product and product has ude's
3.One of the UDE is linked to Floating rate code
4.On the day of creation of this account all values of ude's are given from stdcusac screen
5.Run first eod
5.now on second day go and change rate code ICDRATMA screen
i.e. insert new record with new vale
6.check ICTB_UDEVAL_ROW by querying SELECT * FROM ICTB_UDEVAL_ROW WHERE
COND_KEY LIKE '%&acc%'
7.trigger eod
8.after eod check ICTB_UDEVAL_ROW by querying SELECT * FROM ICTB_UDEVAL_ROW
WHERE COND_KEY LIKE '%KIM00000482469%'
9.new row would have got inserted but apart from the ude for which rate code
was changed i.e. rest all would have become 0

BUSINESS IMPACT
------------------------------
Due to this, margin rate is not updated correctly

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.