Using FTP with AMRT_TYPE_CD = 801, Cash Flows Are Not Generated Until Maturity As Expected
Last updated on DECEMBER 08, 2017
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
On FTP 8.0.4 , it appears that for Cash Flow Duration method, the results in FSI_O_PROCESS_CASH_FLOWS are not generated all the way to maturity.
When using Cash flow duration method for FSI_D_TERM_DEPOSITS with AMRT_TYPE_CD as "801", in FSI_O_PROCESS_CASH_FLOWS, there is only generated data for five dates for all FE 710,720,190,492,493,755,60,100,430,210 even though loaded payment schedule as additional payments defined.
Ideally it should calculate as per payment schedule or till maturity. As per <Document 2289406.1>: "Fixed rate records: The cash flow engine starts from the record's ORIGINATION_DATE and rolls forward by the PMT_FREQ until the MATURITY_DATE.".
The issue can be reproduced at will with the following steps:
1. Testing the results for only one record with below data:
2. Load a payment schedule in FSI_D_PAYMENT_SCHEDULE from 10/17/2016 to 12/20/2017 with amount 500000.00 (equal to CUR_PAYMENT) and on 1/20/2018 as 0 as it maturity date. It also has INSTRUMENT_TYPE_CD 210, ID_NUMBER 801688 and IDENTITY_CODE as 20170228 ( currently running the engine for same date).
3. Run FTP Process using Cash Flow Duration as defined transfer pricing method for AMRT_TYPE_CD = 801.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms