ORA-00001: Unique Constraint (QA.QA_PC_ACTION_TRIGGERS_U1) Violated In Package qa_plans_pub Procedure copy_plan

(Doc ID 2056166.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Quality - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, In Copy Collection Plans page, when attempting to copy a Collection Plan, the following error occurs:

ORA-00001: unique constraint (QA.QA_PC_ACTION_TRIGGERS_U1) violated in Package qa_plans_pub Procedure copy_plan

The issue can be reproduced at will with the following steps:
1. Quality > Setup > Copy Collection Plans

2. in page Copy Collection Plans select:
collection plan type=User-Defined
Collection plan name=FC
Source organization=M1
Press Copy button

3. In New Plan Name column enter new plan name= XX_FC > add destination org > Finish > See error


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