My Oracle Support Banner

Workflow Table Synchronization Error in WF_LOCAL_SYNCH.BulkSYnchronization('HZ_PARTY') (Doc ID 471247.1)

Last updated on OCTOBER 03, 2019

Applies to:

Oracle Workflow - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 07-JAN-2011


Symptoms

The following error when running the concurrent job, FNDWFLSC module, Synchronize WF LOCAL tables:

Name: Synchronize WF LOCAL tables
Parameters: HZ_PARTY, 8, LOGGING

Error either:

a.

ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found



OR


b.

ORA-20002: 4006: While creating necessary indexes, duplicate values were found preventing the
creation of a unique index. This is caused by an improper view definition or data corruption that requires the
attention of the Product Development Team handling 'HZ_PARTY'.
ORA-20002: 4006: While creating necessary indexes, duplicate values were found preventing the
creation of a unique index. This is caused by an improper view definition or data corruption that requires the attention of the Product Development.



-- Steps To Reproduce:
Execute WF_LOCAL_SYNCH.BulkSYnchronization('HZ_PARTY')
BEGIN WF_LOCAL_SYNCH.BulkSynchronization('HZ_PARTY'); END;


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

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