My Oracle Support Banner

GRCI 2.0.1 Using GRCM 7.8 Reports Duplicate Key Error with Action Item on Same Date (Doc ID 1267017.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Fusion Governance, Risk, and Compliance Intelligence - Version 2.0.1 to 2.0.1 [Release 2.0]
Information in this document applies to any platform.
GRCM 7.8 with GRCI 2.0.1


The GRCI 2.0.1 ETL script 'Execute_Load.sql' is run to move the data from the GRCM schema to the GRCI schema.  This error is displayed:

Error report:

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at "GRCI.DIMS_CREATE_PKG", line 2514
ORA-06512: at "GRCI.STAGE_CREATE_PKG", line 773
ORA-06512: at "GRCI.EXEC_LOAD", line 44
ORA-06512: at line 2
01452. 00000 - "cannot CREATE UNIQUE INDEX; duplicate keys found"


In GRCM 7.8 two Action Items were created with the same date. 


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

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