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 APRIL 10, 2017

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

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