BSP No New Business Generated for a Specific Planning Point
Last updated on MAY 05, 2017
Applies to:Oracle Financial Services Balance Sheet Planning - Version 184.108.40.206.7 to 220.127.116.11.9 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)
On BSP 18.104.22.168.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:
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
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