No New Business Results until Second Run of Calculate & ORA-00001 on PK_FSI_FINANCIAL_PLAN
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle Financial Services Balance Sheet Planning - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Balance Sheet Planning (BSP) 18.104.22.168.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
[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.
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