My Oracle Support Banner

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

Last updated on MARCH 26, 2019

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 5.0 and later
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

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.