During Re-ran BSP Export Scenario Definition Duplicate Scenario Name Inserted into Forecast Rates Scenario (Doc ID 2162849.1)

Last updated on JULY 19, 2016

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 Analytical Applications (OFSAA)

Symptoms

On : 8.0.2 version, Calculation Engine

When re-ran Export Scenario Definition duplicate records with the same SCENARIO_NAME inserted into FSI_FCAST_RATES_SCENARIOS table.

Steps:
1. Re-run the Export Scenario Definition rule from the Process Attributes form.
2. Found duplicate records are inserted into the FSI_FCAST_RATES_SCENARIOS table with the same scenario name but a new ID is generated.

select * from FSI_FCAST_RATES_SCENARIOS where scenario_name = 'FCST_APR_INT_RATE_SCN';

FCAST_RATES_SYS_ID

SCENARIO_NAME

SCENARIO_NUM

202161

FCST_APR_INT_RATE_SCN

1

202340

FCST_APR_INT_RATE_SCN

1

200085

FCST_APR_INT_RATE_SCN

1

202321

FCST_APR_INT_RATE_SCN

1

202341

FCST_APR_INT_RATE_SCN

1


Output in the Data_Export log shows 202161:

2016-07-08 11:18:11,535 INFO com.oracle.bsp.udf.ExportTo :: Export Completed : INSERT INTO FSI_BSP_SCENARIO_ATTRIBUTE_T values ('No Year','Forecast','No Version','No Entity','No Chart of Account','No Strategy','No Custom1','S_Attr_1','No Currency','No Financial Element',202161.00000000)

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