My Oracle Support Banner

BSP Current Business Failed with ORA-01400 CANNOT INSERT NULL INTO FSI_ALM_NEW_BUSINESS.PRICING_SYS_ID (Doc ID 2234738.1)

Last updated on OCTOBER 26, 2018

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.1 to 8.0.2.0.7 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.2.0.1 version, Calculation Engine

When attempting to calculate Current Business, the following error occurs.

Error:
fsi_bsp_process_log shows the following:

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


Steps:
1. Completed Metadatasync successfully.
2. Calculate Current Business and it shows failed with error below:
    ERROR OCCOURED WHILE POPULATING BSP PROCESSING TABLES [ORA:ERR] ORA-01400: CANNOT INSERT NULL INTO ("ATOMIC"."FSI_ALM_NEW_BUSINESS"."PRICING_SYS_ID")
3. BSP_Calculation_UnpricesAcc_udf.log :
   Getting the process status
   EPM_ORACLE_HOME : /u01/hypsbtr/Oracle/Middleware/EPMSystem11R1
   OS
   ld.so.1: ofsrm: fatal: libclntsh.so.12.1: open failed: No such file or directory
   Final CFE return status :9
   CFE execution Failed
4. RES_DTL is not created.
5. No ofsrm.log got generated.


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.