'ORA-02437: cannot validate (PK_IOT_FCT_MGMT_REPORTING) - primary key violated' Error Running FN_MGMT_REP_MGMT_LEDGER
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)
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.
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