'New Add Rate' Method Gets Error ORA-01400: CANNOT INSERT NULL INTO ("FSI_ALM_NEW_BUSINESS"."PRICING_SYS_ID") (Doc ID 2175153.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 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.x, when you run a Calculate for a specific COA / Entity combination using a Pricing Method of "New Add Rate" or "New Add Market Rate Spread", you get the following error in the table FSI_BSP_PROCESS_LOG:

[MSG-FATAL]: ERROR OCCOURED WHILE POPULATING BSP PROCESSING TABLES [ORA:ERR] ORA-01400: CANNOT INSERT NULL INTO ("<owner>"."FSI_ALM_NEW_BUSINESS"."PRICING_SYS_ID")

The error occurs during "POPULATION OF BSP PROCESSING TABLES".

Values are output to the RES_DTL_xxxxx table but the pricing margin from Pricing Margin Default is not being used.  You have populated Pricing Margin Default values for the COA / Entity combination being processed.

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