No New Business Results until Second Run of Calculate & ORA-00001 on PK_FSI_FINANCIAL_PLAN (Doc ID 2184003.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

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

Symptoms

In Oracle Financial Services Balance Sheet Planning (BSP) 8.0.2.0.2, when you select a COA / Entity combination without any existing new business forecast, you have to execute the Calculate twice to get new business results.  Prior to the first execution, the balance driver is undefined (has #MISSING in Smart View) and all New Business Financial Elements are blank.  The second time you run, the Calculate creates new business balances successfully.

After the first execution, the following errors exist in FSI_BSP_PROCESS_LOG:

[MSG-FATAL]: ERROR OCCOURED WHILE POPULATING FSI_FINANCIAL_PLAN [ORA:ERR] ORA-00001: UNIQUE CONSTRAINT (HPP_BSP.PK_FSI_FINANCIAL_PLAN) VIOLATED
and
[MSG-FATAL]: ERROR OCCOURED WHILE POPULATING BSP PROCESSING TABLES [ORA:ERR] ORA-01400: CANNOT INSERT NULL INTO ("HPP_BSP"."FSI_ALM_NEW_BUSINESS"."FBAL_SYS_ID")

For the second execution, the errors are gone.

You expect to get results on the first execution.

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