Duplicate Dimension Code Value Issues Noted After BSP Initialization (Doc ID 2260053.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)

Symptoms

On OFSAA 8.0.2, after completing installation and BSP initialization in integrated BSP, there are several issues noted in the integrating instance.

ACTUAL BEHAVIOR
Few issues observed so far:

1 There are duplicates entries passed by BSP initialization process to OFSA_CATALOG_OF_LEAVES/REV_DIMENSIONS_B etc. Which makes ALM process to fail.
2.There are many FSI__MLS tables got inserted with different language codes other than "US'' .These are causing display issues in applications like PFT.
3.There are many direct inserts into rev_dimensions_tl related to Simple dimensions like Instrument data source code. These simple dimensions are not even visible in the Dimension management after BSP initialization completed!

EXPECTED BEHAVIOR

Expect that duplicate data is not created in integrated database after running BSP initialization.

The issue can be reproduced at will with the following steps:
1. Run BSP initialization in integrated instance

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