Synchronize Workflow LOCAL Table Concurrent Process (FNDWFLSC) Fail with Errors ORA-20002, ORA-06512: at "APPS.WF_CORE" (Doc ID 243422.1)

Last updated on APRIL 04, 2016

Applies to:

Oracle Human Resources - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

# fact: Oracle Workflow Directory Service Synchronization
# fact: Oracle Workflow 2.6
# fact: Oracle Trading Community 11.5
# fact: FNDWFLCS - Synchronize Workflow LOCAL Table
# fact: Oracle Human Resources 11.5
# symptom: Synchronize Workflow LOCAL Tables Concurrent Process Fails with
Error
# symptom: Submit processes and Reports throws 'Error' but no other content
# symptom: Manual execution of Oracle Workflow Directory Service
Synchronization process throws complete errors
# symptom: Error: ORA-20002: 4006: While creating necessary indexes,

# symptom: ORA-06512: at "APPS.WF_CORE",
line 285 ORA-06512: at "APPS.WF_LOCAL_SYNCH", line 1192 ORA-06512: at
line 2
# symptom: Concurrent Manager Log for process contains no errors

Changes

# change: Note Role
Implementing Oracle Workflow Directory Service
Synchronization
# cause: Duplicates in HZ_Parties table

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