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 NOVEMBER 29, 2010

Applies to:

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

Symptoms

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"

Changes

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

Cause

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