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:
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