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

(Doc ID 471247.1)

Last updated on FEBRUARY 28, 2018

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

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