My Oracle Support Banner

Aggregated Cash Flow Process Hangs on Delete from FSI_O_PROCESS_CASH_FLOWS When Process Cashflow Table is Large (Doc ID 2325642.1)

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)

Symptoms

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.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.