My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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")



Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.