'New Add Rate' Method Gets Error ORA-01400: CANNOT INSERT NULL INTO ("FSI_ALM_NEW_BUSINESS"."PRICING_SYS_ID")
Last updated on MARCH 09, 2018
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)
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.
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