Cannot insert duplicate row in object AIF_BALANCE_RULES
edited Aug 10, 2017 7:38AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 3 commentsAnswered ✓
Dear all,
I deleted a data load rule from fdmee interface, but now I can't insert a new one.
The following error occurs:
I looked for AIF_BALANCE_RULES_U1 index and it's related with AIF_BALANCE_RULES.RULE_ID only.
Which means that the new value that the application gives for the new RULE_ID exists in the database.
Unfortunately I don't know where this value comes from (which is the table in our PROD_FDMEE database that gives the values to RULE_ID) in order to update it and increase the new value to + 1.
I hope that doing so, I will prevent another duplicate key error.
0