My Oracle Support Banner

ALMBI Transformation Fails With ORA-00001: unique constraint (<atomic>.PK_370) violated Error (Doc ID 2743068.1)

Last updated on JANUARY 26, 2021

Applies to:

Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Enterprise Performance Management (EPM)


On 8.0.7 version, ALM_BI_TRANSFORMATION fails with ORA-00001 error in FSI_MESSAGE_LOG, at insert to FCT_AGG_BASE_CCY_CASHFLOWS.

There is no data present in FCT_AGG_BASE_CCY_CASHFLOWS table however and the cashflows in RES_DTL_XXXXXX table for this process ID is believed to be proper as per validation.



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_370) violated




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

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