Running 'Extract Maturity Mix' from Maturity Mix Default Screen Causes Loss of Data (Doc ID 2125382.1)

Last updated on APRIL 13, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
BSP_MMExport_Seq

Symptoms

In Oracle Financial Services Balance Sheet Planning (BSP) 6.1, you are getting different results in FSI_MATURITY_MIX when you run "Extract Maturity Mix" from Financial Plan Default versus when you run it from Maturity Mix Default.

For example, when you run from Financial Plan Default, it creates 84 rows in FSI_MATURITY_MIX for a product with 6 elements defined.  When you run the same process from Maturity Mix Default, it only adds 72 row to FSI_MATURITY_MIX for a product with the same 6 elements.

Also, if you run Extract Maturity Mix from Maturity Mix Default and you specify a new Year, it overwrites existing rows for the prior year.  As a result, the row count in FSI_MATURITY_MIX decreases instead of increasing for the new year.

You do not understand why you get different results in Financial Plan Default vs Maturity Mix Default.

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