My Oracle Support Banner

FA:SCP: Data Collection Error for Process Work Definition - ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found (Doc ID 2762770.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Supply Planning Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Exchange partition failed for table : MSC_OPERATION_RESOURCES

ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
MSC_OPERATION_RESOURCE_SEQS
The value provided for the attribute DEPARTMENT_CODE is invalid.The value provided for the attribute RESOURCE_CODE is invalid.

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