My Oracle Support Banner

QLTVIEWS.SQL Running As Prerequisite For Publishing QA Plans to ECC Is Returning Error ORA-00001: unique constraint (SYS.I_COL1) violated (Doc ID 2847148.1)

Last updated on AUGUST 09, 2023

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

In QA - Oracle Quality, Version 12.2.10

Problem:

When running $QA_TOP/patch/115/sql/qltviews.sql as prerequisite for publishing QA Plans to ECC (Enterprise Command Center) the following error is returned (see Note 2716251.1 or QA User's Guide in chapter "Setting Up Quality Command Center Access Role")

ERROR at line 1:
ORA-00001: unique constraint (SYS.I_COL1) violated
ORA-06512: at "SYSTEM.AD_DDL", line 210
ORA-06512: at "SYSTEM.AD_DDL", line 402
ORA-06512: at "SYSTEM.AD_DDL", line 1117
ORA-06512: at "SYSTEM.AD_DDL", line 1108
ORA-06512: at "SYSTEM.AD_APPS_PRIVATE", line 260
ORA-06512: at "APPS.APPS_DDL", line 29
ORA-06512: at "SYS.DBMS_SQL", line 1134
ORA-06512: at "APPS.APPS_DDL", line 23
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "SYSTEM.AD_APPS_PRIVATE", line 242
ORA-06512: at "SYSTEM.AD_DDL", line 1049
ORA-06512: at "SYSTEM.AD_DDL", line 347
ORA-06512: at "SYSTEM.AD_DDL", line 197
ORA-06512: at "APPS.QLTVCREB", line 1408
ORA-06512: at line 78

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.