Duplicate Financial Plan code in fin_plans table
search cancel

Duplicate Financial Plan code in fin_plans table

book

Article ID: 420877

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

  • fin_plans table is under consideration
  • It is noticed that two lines in this table have the same code and object_id

Resolution

Uniqueness in this table is defined across three columns - object_id, code and plan_type_code. It is possible to have two records with the same object_id and code. But they would have different plan_type_code.