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
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
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
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!