'ORA-02437: cannot validate (PK_IOT_FCT_MGMT_REPORTING) - primary key violated' Error Running FN_MGMT_REP_MGMT_LEDGER (Doc ID 2288338.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Enterprise Financial Performance Analytics (EFPA) 8.0.2, in a setup that includes custom dimensions, when you run FN_MGMT_REP_MGMT_LEDGER to move data from FSI_D_MANAGEMENT_LEDGER to FCT_MGMT_REPORTING, the batch fails with the following error in FSI_MESSAGE_LOG:

Creating Temporary table IOT_FCT_MGMT_REPORTING
ORA-02437: cannot validate (<atomic>.PK_IOT_FCT_MGMT_REPORTING) - primary key violated

You already added custom dimensions to the FSI_BI_SETUP_TABLE as described in the user guide so you expect them to be included in the primary key.

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