Duplicate Entries in REV_TAB_COLUMNS for STRATEGY_ID After Sliced Upload of BSP Data Model (Doc ID 2177599.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 8.0.1, in an environment that include Balance Sheet Planning (BSP), after you run a sliced model upload in an environment with other applications, you have duplicate entries in REV_TAB_COLUMNS for individual columns one in lower case and other upper case.

Example:

FSI_D_TERM_DEPOSITS has two rows in REV_TAB_COLUMNS for STRATEGY_ID:

COLUMN_NAME
strategy_id
STRATEGY_ID

It appears all of the "FSI_D" tables have the same issue with STRATEGY_ID along with LEDGER_STAT, FSI_O_RESULT_MASTER, and BSP_LEAF_COLUMNS.

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