My Oracle Support Banner

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

Last updated on MAY 01, 2023

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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.