RM Not Using 30/360 Accrual Basis on Records with Payment Schedule
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Risk Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
In Oracle Risk Manager (RM) 4.5.39, you receive negative cash flows (Financial Element 210) for records that have an Accrual Basis of 30/360 (Accrual_Basis_Cd = 1) and use a Payment Schedule. The interest cash flow calculation appears to be incorrectly using an Accrual Basis of Actual/Actual. RM is not using the 30/360 accrual basis from the record. This generates an interest amount that is larger than the payment amount, resulting in the negative total runoff amount.
Beginning Balance: 926,089.70
Current Payment: 10,543
With Actual/Actual Accrual Basis:
Interest Cash Flow = 926089.7 * (0.135 * (31/365)) = 10618.316
Total Runoff (FE 210) = 10,543 - 10,618.316 = -75.316
With 30/360 Accrual Basis:
Interest Cash Flow = 926089.7 * (0.135 * (30/360)) = 10418.509
Total Runoff (FE 210) = 10,543 - 10,418.509 = 124.491
You expect the cash flow engine to use the 30/360 accrual basis listed on the instrument record and generate a positive runoff amount.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms