ORA-00001: Unique Constraint Errors Running ALMBI Transformation for ALM Stochastic Processes (Doc ID 1568416.1)

Last updated on JUNE 05, 2015

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.0.3 and later
Oracle Financial Services Asset Liability Management Analytics - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Asset Liability Management Analytics (ALMBI) 6.0, after running the ALMBI Transformation for a Dynamic Stochastic Process, the following errors are reported in FSI_MESSAGE_LOG:

ERRORS

Number of Rows Inserted Into FCT_STOCH_FCST_INTEREST_RATES:0
Insert Failed from ear_total_dtl_201652 to FCT_AGG_CONS_CCY_EAR_DETAIL: SQLCODE:-1 SQLMSG:ORA-00001: unique constraint (OFSAA_ATOM.PK_FCT_AGG_CONS_CCY_EAR_DETAIL) violated
Insert Failed from to FCT_AGG_CONS_CCY_EAR_AVG: SQLCODE:-1 SQLMSG:ORA-00001: unique constraint (OFSAA_ATOM.PK_FCT_AGG_CONS_CCY_EAR_AVG) violated
Number of Rows Inserted Into FCT_CONS_CCY_STOCH_VAR:405000
Number of Rows Inserted Into FCT_AGG_CONS_CCY_STOCH_VAR:500
One of the Transformation failed: Program Terminated
Number of Rows Inserted Into FCT_FCST_EXCHANGE_RATES:0
Insert Failed from ear_leaf_avg_201652 to FCT_CONS_CCY_EAR_AVG: SQLCODE:-1 SQLMSG:ORA-00001: unique constraint (OFSAA_ATOM.PK_FCT_CONS_CCY_EAR_AVG) violated
Insert Failed from ear_leaf_dtl_201652 to FCT_CONS_CCY_EAR_DETAIL: SQLCODE:-1 SQLMSG:ORA-00001: unique constraint (OFSAA_ATOM.PK_FCT_CONS_CCY_EAR_DETAIL) violated
Number of Rows Inserted Into FCT_CONS_CCY_STOCH_MKT_VAL:810


The issue can be reproduced at will with the following steps:

1. Successfully run ALM Dynamic Stochastic process
2. Confirm rows in all 4 EAR_ output tables
3. Run DIM_RUN Population
4. Run ALMBI Transformation
5. Check errors

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