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 laterInformation 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 |