Calculate on a Large Quantity of Product/Entity Values is Very Slow During BSP_FP_DataExport Step
Last updated on OCTOBER 02, 2014
Applies to:Oracle Financial Services Balance Sheet Planning - Version 6.1 to 6.1.1 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Balance Sheet Planning (BSP) 6.1, when running a calculate on new business for a large quantity of Entity/Chart of Account dimension members, the initial step in the sequence is taking a very long time to complete. The performance is very slow.
The BSP_FP_DataExport step in the BSP_FP_Seq appears to generate a large number of records for intersections of Entity and Product where there is no user input. This step is populating the FSI_BSP_FIN_PLAN_T table in the FSDM schema and is taking a very long time to complete.
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