ALM BI Transform Error Insert Failed for FCT_AGG_BASE_CCY_CASHFLOWS ORA-00001: Unique Constraint (Doc ID 1429584.1)

Last updated on MARCH 05, 2012

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version: 5.6 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Symptoms

On Oracle Financial Services Asset Liability Management Analytics (ALMBI) 5.2.2, when attempting to run the ALM BI Transformation (ALM_BI_TRANSFORMATION) the following error occurs:

ERROR
Error Occured while Inserting data into PRC_LOAD_RES_CONS_DTL for CF Results Insert failed for FCT_AGG_BASE_CCY_CASHFLOWS ORA-00001: unique constraint (ATOMIC.PK_FCT_AGG_BASE_CCY_CASHFLOWS) violated

STEPS
The issue can be reproduced at will with the following steps:
1. Flattened the hierarchies
2. Run SCD and Dimension population
3. Populate DIM_DATES
4. Run ALM_BI Transformation from the command line

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