BSP No New Business Generated for a Specific Planning Point (Doc ID 2262821.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.7 to 8.0.2.0.9 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)
Forecast

Symptoms

On BSP 8.0.2.0.7, there is no new business generated for a specific Planning point at a higher level node and there is a FAILED error in the bsp_process_log:

ERROR
8495 FN_BSP_PROCESSING POPULATION OF BSP PROCESSING TABLES FAILED [MSG-FATAL]: ERROR OCCOURED WHILE POPULATING BSP PROCESSING TABLES [ORA:ERR] ORA-01400: CANNOT INSERT NULL INTO ("BSP_REG"."FSI_ALM_NEW_BUSINESS"."PRICING_SYS_ID") 3/31/2017 9:24 STG-40

The same planning point, processed at a different level gives new business results.

The issue can be reproduced at will with the following steps:
1. Run new business calculation

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