My Oracle Support Banner

Synchronize WF Local Tables Is Obsolete And Does Not Need To Be Run (Doc ID 1158212.1)

Last updated on AUGUST 07, 2024

Applies to:

Oracle Workflow - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
 


Goal

After upgrading to E-Business Applications 11.5.10 ATG RUP6 the concurrent request 'Synchronize WF Local Tables' ends with error.

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

Unable to correctly update the history table - fnd_stats_hist.
ORA-00001: unique constraint (APPLSYS.FND_STATS_HIST_U1) violated



Does this error need to be addressed if not running stats?

Does this concurrent request still need to be run?

Solution

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
Goal
Solution
 Workflow Information Center, Diagnostics, & Community
References


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