My Oracle Support Banner

EPM T2T Data Load Fails with ORA-00001: Unique Constraint (<ATOMIC USER>.FSI_D_CREDIT_LINES_TXNS) Violated (Doc ID 2735606.1)

Last updated on DECEMBER 24, 2020

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to run a Batch for monthly processing, a T2T Data Load to move data from STG_CREDIT_LINES_TXNS_SUMMARY into FSI_D_CREDIT_LINES_TXNS fails with the following error in the T2T log:

Log Message here 1: Tue 08 Dec 2020 08:45:00 AM WAT||DEBUG||Executing Insert Query
FAILED: ORA ERROR : ORA-00001: unique constraint (<ATOMIC USER>.FSI_D_CREDIT_LINES_TXNS) violated

Log Message here 1: Tue 08 Dec 2020 08:45:16 AM WAT||SEVERE||ClsUDBConnect::executeInsertQuery, Error, unable to execute the insert query. ERROR Message: ORA-00001: unique constraint (<ATOMIC USER>.FSI_D_CREDIT_LINES_TXNS) violated

Log Message here 1: Tue 08 Dec 2020 08:45:16 AM WAT||DEBUG||ClsUBatchLoader::Bulk : Error Messaage : ORA-00001: unique constraint (<ATOMIC USER>.FSI_D_CREDIT_LINES_TXNS) violated

Log Message here 1: Tue 08 Dec 2020 08:45:16 AM WAT||DEBUG||ClsUTableToTableLoad::Bulk, Number of rows loaded: 104
Log Message here 1: Tue 08 Dec 2020 08:45:16 AM WAT||SEVERE||Loading Failed, Number of erroneous records exceeded the reject limit

There are also two rows in the table FSI_D_CREDIT_LINES_TXNS$ with identical values.

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


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