BSP ORA-00001 Unique Constraint for FSI_MATURITY_AUXILIARY (Doc ID 2115856.1)

Last updated on OCTOBER 06, 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

When running a complete calculation for an entity, the following error occurs in FSI_BSP_PROCESS_LOG.

Error:
PR_MATURITY_MIX_OVERRIDE
ERR:INSERTS FSI_M_MATURITY,FSI_MATURITY_AUXILIARY ORA-00001: UNIQUE CONSTRAINT (BSP.XAK1FSI_MATURITY_AUXILIARY) VIOLATED

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



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