BSP Cash Flow Engine Slow Performance During PR_BSP_POPULATE_PRICING_MARGIN
(Doc ID 2443074.1)
Last updated on SEPTEMBER 06, 2018
Applies to:Oracle Financial Services Balance Sheet Planning - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 22.214.171.124.3 version, Calculation Engine
BSP Cash Flow Engine performance is degrading and found the long running sql is on PR_BSP_POPULATE_PRICING_MARGIN and delete from FSI_M_PRICING_MARGIN.
Steps to Replicate:
1. Patched BSP to version 126.96.36.199.3.
2. Performance issue with Cash Flow Engine performance.
AWR report shows that PR_BSP_POPULATE_PRICING_MARGIN and delete from FSI_M_PRICING_MARGIN.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document