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 SEPTEMBER 21, 2017

Applies to:

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


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


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


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