EFPA ORA-00001: unique constraint (OFSATOMIC.PK_1300) violated Running Batch to Load Management Ledger to FCT_MGMT_REPORTING Table (Doc ID 2302569.1)

Last updated on AUGUST 30, 2017

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.4 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 Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Reporting

Symptoms

On EFPA 8.0.4, When running the batch to load data from FSI_D_MANAGEMENT_LEDGER to FCT_MGMT_REPORTING table the below error appears:

ERROR
"Error Occured: ORA-00001: unique constraint (<atomic>.PK_1300) violated"

After analysis it is found that when checking the source data with identity code in the FSI_D_MANAGEMENT_LEDGER it shows no duplicates. but when grouping the data on all columns excluding identity code, there are few duplicates.
Currently, IDENTITY_CODE exists in the unique index column of FSI_D_MANAGEMENT_LEDGER, but not in the FCT_MGMT_REPORTING table.

There are few allocation rules which write output to the same dimension combination. Due to this there different identity codes generated but the dimension combination remains same in the management ledger.

The issue can be reproduced at will with the following steps:
1. Run the batch to load data from FSI_D_MANAGEMENT_LEDGER to FCT_MGMT_REPORTING table

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