FDM Error Upon Check Step of Workflow "ORA-00001: unique constraint (HYP_FDM.PK_TDATACHECK) violated" (Doc ID 1603075.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.1.3.00 and later
Information in this document applies to any platform.

Symptoms

When running the export/load operation from FDM to Hyperion Financial Management (HFM) the load of the data completes successfully, but when the Check report should be displayed the following error is returned:

ERROR:
Code............................................. -2147217873
Description...................................... Duplicate key found, Insert/Update failed.
ORA-00001: unique constraint (HYP_FDM.PK_TDATACHECK) violated
Procedure........................................ clsDataManipulation.fProcessRecord
Component........................................ upsWDataWindowDM
Version.......................................... 1111
Thread........................................... 4528

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