Aggregated Cash Flow Process Hangs on Delete from FSI_O_PROCESS_CASH_FLOWS When Process Cashflow Table is Large
Last updated on DECEMBER 14, 2017
Applies to:Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
When the first time to run the ALM Static Deterministic Process for FSI_D_CASA process, it took around 5 hours to complete. However, when some values were changed in the data and the ALM Static Deterministic Process is re-executed for FSI_D_CASA that has around 2.6 million records in it for a particular AS_OF_DATE, it hangs on 'delete from fsi_o_process_Cash_flows where result_sys_id =XXXX',
This is a performance issue which is causing the process to run for almost 19 hours.
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