My Oracle Support Banner

New Business Output to Wrong CUSTOM Dimension Value During Calculate (Doc ID 2227248.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.2 to 8.0.2.0.5 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Balance Sheet Planning (BSP) 8.0.2.0.2, when you run a Complete Calculate, the wrong dimension value is assigned to CUSTOM1 for the New Business rows output.  For example, you enter CUSTOM1 = 5 when launching the Calculate.  However, checking the results in the RES_DTL_xxxxxx table, for some products, the New Business rows with RESULT_TYPE_CD = 1 have CUSTOM1 = 4.  You expect these products to have CUSTOM1 = 5.  Some products do have the correct CUSTOM1 =5 values.

The following error exists in the FSI_BSP_PROCESS_LOG table:

[MSG-FATAL]: ERROR OCCOURED WHILE POPULATING FSI_FINANCIAL_PLAN [ORA:ERR] ORA-02291: INTEGRITY CONSTRAINT (BSPAPP.FK_FSI_M_FORECAST_BAL_2) VIOLATED - PARENT KEY NOT FOUND

You are not sure if the error is related to the issue populating CUSTOM1.

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