Calculate on a Large Quantity of Product/Entity Values is Very Slow During BSP_FP_DataExport Step

(Doc ID 1931786.1)

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)

Symptoms

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.

Cause

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