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 03, 2019

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

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.